AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N4751UPlano Daniel W · Willow, AKN4752CShannon Alton P · Intl Falls, MNN4752SRion Aviation Corporation · Wilmington, DEN4753FRobertson Robin L · Murfreesboro, TNN4753NSimmons Todd B · Cowley, WYN4753UTurchan Robert H · Scottsdale, AZN4754EJrm Property LLC · Taylors, SCN4754NBrentco Aerial Patrol Inc · Canton, OHN4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4756DVertical Investment Strategies LLC · Henderson, NVN4757FMulcaire Jess E · Camp Verde, AZN4757NTwin Falls Fliers Inc · Twin Falls, IDN4757THagen Brian T · Allen, TXN4757UPj Aviation LLC · Eden Prairie, MNN4758BJaars Inc · Waxhaw, NCN4758DBurt William G · Tullahoma, TNN4759BHoover Michael B · Ridgeland, WIN4759NMitchell Robert L · Presque Isle, MIN475LN475l LLC · Boise, IDN4760CJaars Inc · Waxhaw, NCN4760EYoung John L · Glorieta, NMN4761CForbis Aviation LLC · Calera, OKN4761DNordstrom Anne D Trustee · Walpole, NHN4761EDorsheimer Ryan J · Camp Hill, PAN4762BAllen Kenneth W · Anchorage, AKN4763NBathum Dale · Ketchum, IDN4763UCopper River Airmotive LLC · Copper Center, AKN4764NWhite Robert H · Eagar, AZN4764URegistered aircraftN4765TWehrman David Hugh · Queen Creek, AZN4766DHutchison Frank J · Tucson, AZN4766UMoore Murray H · Twain Harte, CAN4767DFulton Daniel M · Blacksburg, SCN4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORN4767UDeckload Aviation LLC · Kodiak, AKN4768BEversole Eric L · Kent, WAN4768DBoyd Amy L · Kila, MTN4768FZankiz Jose Carlos · Naples, FLN4768NTreadwell Dennis A · El Cajon, CAN4769BNesbett David A Trustee · Anchorage, AKN4769NTurner Luke · Mineral Wells, TXN4769TBowsap LLC · Manson, WAN476CACivil Air Patrol · Maxwell Afb, ALN476DWSkylane Capital Group LLC · Seattle, WAN476KETrexel Paul C · Willits, CAN476LSHoffman Anthony J Trustee · Hillsboro, ORN4770DNapier Michael D · Russell, KYN4771ULoomis Rick A · Prescott, AZN4773BRegistered aircraftN4773CDickert Daniel · Cross City, FL
Back to AD 84-10-01 R1