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.
N656DMKingsky Flight Academy LLC · Lakeland, FLN656EZJames Sean · Cresson, TXN656FTFlorida Institute Of Technology Inc · Melbourne, FLN656GCotter Kevin G · Chico, CAN656JSLachausse Jeffrey B · Hilton, NYN656MFMelbourne Flight Training LLC · Melbourne, FLN656NDUniversity Of North Dakota · Grand Forks, NDN656RBBas Part Sales LLC · Greeley, CON656SSwann Kim Trustee · Toledo, OHN656SFSkyfusion II LLC · Atlanta, GAFirst renewal noticeN656SPChristiansen Aviation LLC · Wilmington, DEN656TSN656ts LLC · Stuart, FLN656WCT3 Aerosports LLC · Vian, OKN656WTAngelette Timothy B · Thibodaux, LAN65702Mitchell Myron W · Advance, NCN65703Gonzalez Henry M · Miami, FLN65704Skywarrior Flight Training Inc · Pensacola, FLN65709Maverick Jet Leasing Corp · Wilmington, DEN6570HBritten Air LLC · Natchitoches, LAN6570JJenkins Robert Martin · Westminster, MDN6570LHack Mark K · Chatsworth, GAN6570RBellas Business LLC · Kalispell, MTN6570WMurillo Raymond · Pico Rivera, CAN65710Beach Cities Aviation Academy LLC · Hawthorne, CAN65714Ferrick James F DBA · Mechanicville, NYN65716Rtd Aviation LLC · Hillsborough, NJN6571DBlazing Sun Aviation LLC · Encinitas, CAN6571HHentges Dave · Canby, MNN6571JLima Alpha LLC · Pearcy, ARN6571UCrabtree Martin L · Sedalia, MON65722Red River Aviation Services LLC · Altus, OKN65723Brutger Wayne · Little Falls, MNN6572DWalkowicz Eddie · Garland, TXN6572JFletchall Jeremy S · Queen Creek, AZN6572WBoydstun Saylor Krystene · Brady, TXN65730Chuchuca Espinoza Jorge A · Clifton, NJN65731Christ Jacob A · Mandeville, LAN6573DPeabody Jeffery L · Vinemont, ALN6573JBeecher Bees Inc · Beecher, ILN6573LBreland James · Laurel, MSN6573PCoil Ian M · Carroll, OHN6573UAlvis Michael E · Lumberton, NCN6573WKing Isaac · Coahoma, TXN65741Flycarolina LLC · Charlotte, NCN65742Mustang Sally Aviation LLC · Camden, SCN65743University Of Central Missouri · Warrensburg, MON65746Son Cameron D · Groveland, FLFirst renewal noticeN6574DFly Carolina LLC · Concord, NCN6574GPplforu LLC · Fort Worth, TXN65750Christiansen Aviation LLC · Wilmington, DE
Back to AD 90-04-06 R1