AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N16CJRoyale Air Service Inc · Fort Myers, FLN16DBDivan Richard W · Wautoma, WIN16EDSimply Living LLC · Fort Myers, FLN16EFAnything Aviation LLC · Fort Lauderdale, FLN16EKCenterline Holdings LLC · Belgrade, MTN16FHodge Justin Eugene · White Sands, NMN16GBWester Lawrence Cale · Star, IDN16GPDeckload Aviation LLC · Kodiak, AKN16HTAviation Specialties Unlimited Inc · Boise, IDN16KFFournier Louis W · Fort Worth, TXN16KNIgwt Holding LLC · Richardson, TXN16MMGoff Bruce J · Williamstown, MAN16MSEnergy Transfer Aviation LLC · Spring, TXN16PFTurbine Financial Group LLC · Ogden, UTN16QCDawson Aircraft Inc · Clinton, ARN16RRAustin Donald E · Ripley, MSN16SBZabel Victor R · Albuquerque, NMN16SHDickinson James C · Haslet, TXN16VCStallion Leasing LLC · Louisville, KYN16VVLaughlin R C Jr · Boerne, TXN16WLLivingston Patricia R · Wasilla, AKN17001Shields David A · Saylorsburg, PAN17004Depietro Shelley Jo · Olympia, WAN17009Wight John I · Anchorage, AKN1700CKrause Kade G · Jackson, MTN1700MDeltahawk Engines Inc · Racine, WIN1700QAtkinson Jonathan E · Chapmansboro, TNN1701Rolston Charles W · Shoreview, MNN17014Alcorn Paul W · Bay City, MIN17016Mika Brian D · Andover, MNN17019Reed James W · Boulder City, NVN1701RM R Planes LLC · Redmond, WAN1701VBeach Chad T · Kilgore, TXN17021Fletcher John Guy · Diamondhead, MSN1702CCork Dennis R · Soldotna, AKN1702EExecutive Flight Institute LLC · Murrieta, CAN1702QStrutzenberg Kent R · Manson, IAN1702RDaniel Boone Flying Club Inc · Booneville, MON1702VClassic Rotors Museum · Ramona, CAN17033Browning Brad T · Lake Park, MNN17039Davidson Luke H · Gilmer, TXN1703MNesloney Thomas Jeffery · Hilltop Lakes, TXN1703QTroutman Noah M · Owensboro, KYN17043Coleman Sherod · Houston, TXN17045Streichenwein Scott F · Salisbury Mills, NYN17047Sickinger Alan W · New Philadelphia, OHN17048Myob Group LLC · Ocala, FLN17049101 Inc · Bejou, MNN1704QOlfert Ronald W Trustee · Frazer, MTN1704UKuspuk School District · Aniak, AK
Back to AD 97-01-13