AD 90-04-06 R1
Registered aircraft · 68,369
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.
N26082Hunt Edmond L · Madison, WVN26085Van Nostran Seth A · Doylestown, OHN26086Joe Hoerter LLC · Hilton Head Island, SCN26087Enger Kenneth H · Mesa, AZN2608GStrom Gordon B Md · Paris, TXN2608MEhrenfelt Linda Mae · Pierre, SDN26094Hall George M · Blooming Grove, TXN26098Chaput Armand J · Austin, TXN2609EMakotyn Andrzej · Northbrook, ILN260EMMartin Edward I · Trinity Center, CAN260EZMurphy John F · Ann Arbor, MIN260FAStratus Rr LLC · New Castle, DEN260JEMccutchen David W · Dickson, TNN260JKKnight John S · Brewer, MEN260NDPlane Nonsense Inc · Middletown, DEN260RGKelley Jacob Scott · Vail, AZN260RJHitterman James D · Metropolis, ILN260SGEsteban Granwel Genio Jr · Johnson City, TNN260UBoard Of Regents Of The University Of Oklahoma · Norman, OKN260VMMaday Matthew · Tahlequah, OKN26100Carey International Aviation Services LLC · Rockville Centre, NYN26103Williams Richard · Atlanta, GAN26104Sumner Gary W · Knoxville, TNN26106Polymer Depot LLC · Delafield, WIN2610AGreen-Way Essentials LLC · Arkansas City, KSN2610RStable Aviation LLC · Eagan, MNN26114Flyinisme LLC · Saint Augustine, FLN26116Fasske Wayne · Crossville, TNN2611PRegistered aircraftN26120Houk David A Jr · Norton, OHN26122Smile Givers · Chico, CAN26124Chapman Edward J DBA · Jordan, MNN26127Rose David Alan · Port Orange, FLN2612MGreenhalgh Janna L · Caldwell, IDN2612ZStewart Jon L · Walker, MNN26130Bokkers Maike L · Mountain View, CAN26132Active Pilot Solutions Inc · Van Nuys, CAN26136Aoki Nidal · Porter, TXN2613PBraun Daniel R · Damascus, ORN26142Stamper George William III · Quinton, VAN2614ADixon Eric A · Salado, TXN2614DRegistration Pending · Kerrville, TXRegistration pendingN2614GNorthern Air Inc · Bonners Ferry, IDN2614VMorris Daniel J · Bossier City, LAN2615MKelsey Mike · Carey, IDN2615WSturgis Joel B · Pensacola, FLN26160Wilson William J · Houston, TXN26163Brown Michael D · Elk Grove, CAN26165Moldt Richard W · Montrose, CAN26167Mowery Ronnie G · Spencer, OH
Back to AD 90-04-06 R1