AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7261QSchilling Aviation Services LLC · Salina, KSN7261WKurywchak Daniel A · Cameron Park, CAN7261YKocak Robert G Jr · Peoria, AZN7262FParlee Chad E · Lakeport, CAN7262JKemp Lyman E · Ketchikan, AKN7262QFlikins Barbara L · Fillmore, CAN7262WDube Colin T · Minot, MEN72639Dischler Stephen · New Lisbon, WIN7263GHardy Chad A · Rush City, MNN7263JKl Aviation LLC · Catawba, NCN7263PHoffman Raymond F · Encinitas, CAN7263QWyatt Barbara Louise · Cheyenne, WYN7263WKontour Shawn K · Wheatland, WYN7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEN7264Godsil Donivan · Oneida, ILN7264FPodyaire LLC · Ruston, LAN7264JHoseney Richard W Jr · Como, MSN7264LLarson Aircraft LLC · Sandy, UTN7264QAdams Rick B · Ashford, WAN7264WFehringer John T · Sidney, NEN7264YYogi Air LLC · Wadsworth, OHN72650Mecham Gerald W Jr · Mesa, AZN72653Atp Aircraft 2 LLC · Wilmington, DEN7265BHolladay Aviation LLC · Jacksonville, FLN7265FShouling & Philip Enterprise · Lancaster, CAN7265JSwoboda Charles · Anchorage, AKN7265KSale Reported · Phoenix, AZSale reported, canceledN7265LGulfstream Aerospace Corp · Savannah, GAN7265WSayles Michael A · Shorewood, ILN7265ZAtp Aircraft 2 LLC · Wilmington, DEN72662Jwa Flight School LLC · Bolingbrook, ILN72664Advanced Aviation Group LLC · Frederick, MDN7266DMelbourne Flight Training LLC · Melbourne, FLN7266JPaolo Keath R · Carlton, ORN7266QLima-001 LLC · Muscatine, IAN7266WNewland Hunter R · West Valley City, UTN7267FRegistered aircraftN7267GWells Jack D · Newtown, MON7267JSe Aviation LLC · Boise, IDN7267WGillespie Michael Lee · Jacksonville, FLN72681Riggs Benjamin D · Reynoldsburg, OHN7268DLarsen Daniel R · Kenai, AKN7268LFletchair Inc · Comfort, TXN7269FChandler Joseph · Amana, IAN7269GBranson Barry R · Shasta Lake, CAN7269QBaker Mark · White Bear Lake, MNN7269WButtercup Express LLC · Woodward, OKN726ACGrass Roots Aviation LLC · Bend, ORN726AJStarr Alan D · Senoia, GAN726AMRegistered aircraft
Back to AD 90-04-06 R1