AD 94-05-05 R1
Registered aircraft · 26,232
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.
N7315MRolling Cole LLC · Kalispell, MTN7316ALangley Russell M · Adair, OKN7316MSteven Bryant · Boise, IDN7316XMattson Nicholas R · Vail, AZN7318MOttis David J · Norfolk, NEN7319AHart George · Yuba City, CAN7319MCordes Hannah K · Winthrop, WAN731XSchorsch Kerry · New England, NDN7320TRegistration Pending · Shepherdsville, KYRegistration pendingN7321TDelaney Glen W · Canyon, TXN7322ABaas Keith L · Alto, MIN7322GHolt Thomas H · Griffin, GAN7322MDeasy Brendan W · Berlin, NHN7322TSchaub John P · Darlington, INN7322XHogan Robert Leroy · Depew, OKN7323XBrandt Goetz K · San Jose, CAN7324MBehrends Brandon R · Duluth, MNN7325AJaeger Howard E · Claremore, OKN7325TCierra Rose Morgan Shawe · Seattle, WAN7326MCammack Steve · Round Rock, TXN7327ACordova Coast Inc · King Salmon, AKN7327TBanister James M · Florence, MTN7327XAreopagita Ronnel · Linden, NJN7328AToribio LLC · San Antonio, TXN7328TPickett Griffith Randall · Kansas City, MON7329ASargent Evan · Camas, WAN7330MJorgenson Brian K · Sandpoint, IDN7330TBrazos River Aviation Group LLC · Mineral Wells, TXN7331AAviation 98374 LLC · Bonney Lake, WAN7331TRothenberger Stanley D · Topeka, KSN7331XPorter H Tom · Columbia, MSN7332MNorthern Flyers LLC · Bemidji, MNN7333Asher Charles S · Grosse Ile, MIN7333TMyl High Flying Club LLC · Mccall, IDFirst renewal noticeN7334HThompson Frank L · Weiser, IDN7334THunter Jeffrey D · Wolfforth, TXN7334XElliott Frank F · Mojave, CAN7335APomeroy Keith R · Port Saint Lucie, FLN7335HHangar 39 LLC · Culpeper, VAN7335XTowery Katy L · Dover, DEN7336ARanger Aviation Inc · Burlington, CON7336MYates Christopher Lynn · Edmond, OKN7337MRexwinkle Thomas L · S Coffeyville, OKN7337TWallace Austin · Oregon City, ORN7338XSahagun Salvador G · Bothell, WAN7339ARentfrow Jack D · Lake City, MIN7339XRenewed Inc · Tekamah, NEN7340XKohut Robert J · Sag Harbor, NYN73417Lindquist Charles Q · Hettinger, NDN7341MSobczyk Scott R · Hartford, WI
Back to AD 94-05-05 R1