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.
N4214QMms Aircraft Leasing LLC · Williamsburg, VAN4214YAngran Nate J · Albia, IAN4215HDavis John N · Port Alsworth, AKN4215YCg Air LLC · Mason City, IAN42161Registered aircraftN42166Snyder Jon · Charlotte, NCN42167Howarth Jason A · Lancaster, PAN42168Registration Pending · Denton, TXRegistration pendingN4216TExtreme Metals LLC · El Dorado, ARN4216YTusquittee Flyers Aero Club LLC · Hayesville, NCN4216ZGleason Egan · Valdez, AKN4217HBowser Dwight H · Anchorage, AKFirst renewal noticeN4217JShuffler David · Kingman, AZN4217PInternational Air Services Inc Trustee · Carson City, NVN4217TBentzen David A · Deer Park, WAN4217ZSchock Erik D · Wasilla, AKN42183Van Wagner Aerial Media LLC · Hollywood, FLN4218HGenna Aviation LLC · Newfield, NJN4218MFordyce Gregory L · Gaston, ORN4218PPn4 Aviation Holdings LLC · Bishop, CAN4218QSavant John D · Kinder, LAN4218TGolden Pick LLC · Maple Plain, MNN4218YDaniels David R · El Paso, TXN4219FHazellief Quillie J Jr · Okeechobee, FLN4219HHardman Lorin D · Wasilla, AKN4219QAudrain Flying Club Inc · Mexico, MON4219ZBubber Inc · Lake Providence, LAN421ACCroft Dennis W · Spencerville, OHN421AKMcgregor Grant · Chugiak, AKN421BSSell Robert O · Prescott Valley, AZN421BTJolley Robert W · Comanche, TXN421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WAN421DLLaplant James R · Newton, IAN421MJLevine Jonathan L · Waterford, CTN421PTRozneck Paul E · Edmond, OKN421SKrehbiel Timothy D · Bern, KSN422Datum Aviation LLC · Milton, FLN4220GVoorhies Danny L · Albertville, ALN4220HHutchinson Keith M · Lancaster, TXN4220JHisghman Jonathan G · Waynesboro, VAN4220ZLonon Michael E · Yuba City, CAN42212Caves Xxi Properties LLC · Virginia Beach, VAN4221DAntique Preservation Associaiton Of Greenfield · Greenfield, IAN4221JKeystone Aviation LLC · Melrose, FLN4221QRegistered aircraftN4221TEralet Inc · Middletown, DEN4221ZBlue River Aviation LLC · Palmer, AKN4222Barry Edwin R · Apple Valley, CAN4222HCre Aviation Holdings LLC · Ramona, CAN4222JHerrera Justin C · Willits, CA
Back to AD 90-04-06 R1