AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N180HPorter Jeff S · Aguila, AZN180HPRobinson Michael D · Folkston, GAN18100Liberty University School Of Aeronautics · Lynchburg, VAN18104Toth Stephen K · Northampton, PAN18108Larsen Kevin L · Firth, IDN18109Szoke Elliott · Mukilteo, WAN1810NMetzler Darwin H · Manheim, PAN1810YLussier Lisa · Greene, RIFirst renewal noticeN18110Radke Steven H · Hastings, MNN18115Hinds Community College · Raymond, MSN1811CEastburn Maurice H · Peyton, CON1811EEndres Sam D · Gainesville, TXN18126Harroun Charles G · Maryville, MON1812KMichaelsen Mark R · Leesburg, VAN1812NRutherford Kevin · Sheridan, ARN1812YHopkins Mark W · Emporia, KSN1813KWilliams Jay P · Moses Lake, WAN1813VCodingflyboy LLC · Hayward, CAN18140Johnroe Ryan M · Mount Pleasant, MIN18144Kachemak Bay Flying Service · Temple, TXN18145Stlouis Aviation LLC · Miramar, FLN18155Willis Nathan Eric · Broken Arrow, OKN18157Matz Robert D · Niles, MIN1815BHaugen Michael C · Oklahoma City, OKN18162Pruzek Richard L · Chippewa Falls, WIN18163Wings Aero LLC · Zeeland, MIN18164Cendejas Agustin · Chino, CAN18167Be Chara Niz Ar E · Columbia, MDN1816BBuchanan Karen K · North Hampton, NHN1816CCalvert Tobin R · San Antonio, TXN1816KCartledge Douglas J · Seville, OHN1816YNicholas Thomas M II · Enid, OKN18171Isaacson Arthur T · Hillsboro, MON18173Bb Aero Works Ltd · Whitehouse, OHN18177Hoffman Rick W · Elk River, MNN1817BSlack Jonathan D · Bonfield, ILN1817VHarper James J · Miller, MON18180Woodward Aviation · Varnville, SCN1818BWilliams Timothy W · West Monroe, LAN1818NFirth Thomas H IV · Sonora, CAN18197C150 Holdings LLC · Newark, DEN18198Ohare Douglas K · Ainsworth, NEN18199Forthman Scott Chance · Miami, FLN1819CFischer Douglas J · Palermo, CAN1819NPower Terry Edward · Council, IDN1819VSparebanc LLC · Appleton, MNN181HRevoir Scott R · Hastings, NYN181TTWilson James · Bagwell, TXN181VVScriva Jennifer L · Sherwood, ARN18200Morristown Flying Service Inc · Talbott, TN
Back to AD 94-05-05 R1