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.
N4714KJld Air LLC · North Hampton, NHN4714RAlford William J · Erie, MIN4714YSoukup Matthew J · Eagle River, AKN4715JClarke Brent H · Neversink, NYN4715LSmith Bryan E · Mt Juliet, TNN4715ZMuehlberg Stephen E · Newcastle, OKN4716LLong Steven M · Baton Rouge, LAN4717AOppegaard Craig E · Saint Louis Park, MNN4717BCoastal Flight Inc · Tierra Verde, FLN4717JBrock Aviation Flight School LLC · Douglasville, GAN47189Xclusive Level Aircraft World LLC · Kissimmee, FLN4718AQuinby Gary D Trustee · Ardmore, OKN4718KMayes John · Carson City, NVN4718LSnt Aviation LLC · Laurel, MSN47193Cloud Dancer Aviation Inc · Deland, FLN4719AAvquest Aviation Services LLC · Montgomery, NYN4719FFrederick Joel · Hobe Sound, FLN4719LMinderman David J · Westlake, OHN471AArcher Aircraft LLC · Wilmington, DEN471ACWard Allen M · Andalusia, ALN471AKAkima Logistics Services LLC · Usaf Academy, CON471AMWells Alex E · Bend, ORN471ATAirmen Testing & Training Inc · Lantana, FLN471BHRocky Mount LLC · Kalispell, MTN471FJForeman Frank A · Call, TXN471HCHinds Community College · Raymond, MSN471JROrtiz Rivera Jose E · Bayamon, PRN471KWheeler M Andrew · Westfield, INN471MHHughes Michael J · Mayville, WIN471NPGallant David A · Hartsel, CON471PRRed Arrow Aviation LLC · Santa Teresa, NMN471SPPine Ventures LLC · Malmo, NEN47204Reinhardt Michael J · Tonawanda, NYN4720AP P & J LLC · Gillette, WYN4720BAffiliated Air Services Inc · Vincentown, NJN4720FBennett Ronald W · North Pole, AKN4720RHotkeys Holding LLC · Silver Spring, MDN4721BEuro 2000 Inc · Merritt Island, FLN4721LLee Christopher S Sr · Quinton, VAN4721RWaterdawg Express LLC · Pocatello, IDN47225Aviation Partners Inc · Carson City, NVN47227N47227 Inc · Hobe Sound, FLN4722AJoos Devon T · Menlo Park, CAN4722SStallman Jon · Chico, CAN4723BEuro 2000 Inc · Merritt Island, FLN4723PChristiansen Aviation LLC · Wilmington, DEN4723RSmolkin Alexander S · North Chesterfield, VAN4723ZMartin William S · S Coffeyville, OKN4724JRegistration Pending · Orlando, FLRegistration pendingN47253De Wan Madisun Nicole · Tarpon Springs, FL
Back to AD 90-04-06 R1