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.
N4449GHuntley John · Bellingham, WAN4449RMorrow David · Maynardville, TNN4449XBurns William R · Greensboro, GAN444AASipola Don H · Virginia, MNN444BSSiemens Christopher L · Seminole, TXN444CLK G L Aviation Inc · Villisca, IAN444FRegistration Pending · Auburn, CARegistration pendingN444GENeverland LLC · Emerson, IAN444GMTwo W Aviation LLC · Casper, WYN444LLWolfson Alan B · Loveland, OHN444PJWagner Aviation LLC · Laura, OHN444RWBackus Gary Carl · Chesapeake, VAN444VBYoung Reginald S · Buffalo Junction, VAN444VCGa Flying LLC · Jupiter, FLN444XPEiron Nadav · Portola Valley, CAN4453CKesinger Steven W · Fremont, CAN4455CJohnson Kyle A · Cheshire, CTN4458CMarken Jeffrey R · Baker, FLN4459CHankins Shannon G · Tulsa, OKN445CPCivil Air Patrol · Maxwell Afb, ALN445DCWith Wings As Eagles Aviation LLC · Middletown, DEN4467CNighthawk Air Systems Inc · Palmetto Bay, FLN4468CCommand Aire LLC · Sitka, AKN4468NN4468n LLC · Loganville, GAN4469CDenair Inc · Clifton Springs, NYN4474CSlipshod Aviation LLC · Hurricane, UTN4476CBoatman C L · La Porte, TXN447CPCivil Air Patrol · Maxwell Afb, ALN447ESRegistered aircraftN447WLM5-210c LLC · Castle Pines, CON4480CTupelo Aeronautics Inc · Tupelo, MSN4484CHoward William D · Coupland, TXN4486CUniversity Bancorporation Inc · Downers Grove, ILN4487CBaldeo Kessho I · Bay Shore, NYN4488CNix Terry W · Golden, MSN4488SMartens Paul A · Fairview, OKN4489CInabnit Shon G · Colville, WAN448AKN448ak LLC · Helena, MTN448ALWheeler Alexa L · Tavernier, FLN448BBHawkflight LLC · Sugar Land, TXN448ESSchaefer Mark D · Oconomowoc, WIN448RJRonald Janis · New York, NYN448TDSteel And Supply Co Inc · Tuscaloosa, ALN449Destroyla Inc · Los Angeles, CAN4492CYates Daniel A · Saint Louis, MON4494CWest Thomas P · Bridgeport, OHN4495CAustin Cody · Pflugerville, TXN4498CGoettl Karl T · Clarkdale, AZN449SFKyle Allyn B · Snohomish, WAN449VYKirkham Matthew · Cazenovia, WI
Back to AD 84-10-01 R1