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.
N5637MAmelia Reid Aviation LLC · San Jose, CAN5637UCurtis Alex K · Winnemucca, NVN5637ZKutcher Dennie L · Galeton, CON56380Zimin Carl E · Naknek, AKN56382Risley Air LLC · Myrtle Beach, SCN56386Airmooney LLC · Amherst, NYN56387Prentice Robert D · Ripon, WIN5638HHoudek Dennis E · Roseburg, ORN5638QThomas E O'Gorman · Yreka, CAN5638ULig Tyl LLC · Akron, NYN56390Renard Jerome L Trustee · Curtis, NEN56393Rotheroe Peter L · 81827 MunchenN56396Sky North Aviation & Flight Training LLC · Arbuckle, CAN5639FTaffet Jay · New Orleans, LAN5639HKruse Bryan J · Bethel, AKN5639MPayne Maurice A · Bensalem, PAN5639PMarchetti Nancy K · Port Charlotte, FLN5639UMcconnell Charles L · Phoenix, AZN563APa28 Aircraft LLC · Wilmington, DEN563CARegistration Pending · Wilmington, DERegistration pendingN563DRural Air Medical LLC · Farmington, UTN563DEGordon Don · Melba, IDN563DFGolden Aviation LLC · Hillsborough, NJN563FLParkerson James R · Greenville, MSN563GLBole David M · Auburn, WAN563KAtp Aircraft 3 LLC · Wilmington, DEN563MAHot Wings Aviation LLC · Indianapolis, INN563PJMcdonald Patrick J · Des Moines, IAN563PUAri Ben Aviator Inc · Fort Pierce, FLN563SBWalker Linda V · Zeeland, MIN563SCSpartan Education LLC · Tulsa, OKN563TDGlenn Jeff P · Billings, MTN563WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN563WWJimenez Daniel L · Goodyear, AZN56404Mark Lindstrom · Fort Worth, TXN56406Blankenship Tyler D · Salisbury, NCN5640EHunt Jacky R · Bowling Green, KYN5640HMitchell Zachary · Franklin, NHN5640NK Top J Cattle Co LLC · Eldorado, TXN5640QProps To You LLC · Mount Pleasant, SCN5640UJustfly Inc · Houston, TXN56410Ehrler Andrew N · Flushing, NYN56413Hupert Jason M · Grand Blanc, MIN56414Gordon David P · Truckee, CAN56418Shepler John E · Mobile, ALN5641AGrandy Leland P · Rock Springs, WYN5641VFlight Leasing Corp · Wilmington, DEN5641WThibodeau Tom M · Kenai, AKN5641ZScout Aviation LLC · Arnaudville, LAN56424Saunders Equipment Inc · Cold Spring, NY
Back to AD 90-04-06 R1