AD 94-05-05 R1
Registered aircraft · 26,230
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.
N83964Tesmer Air LLC · Libertyville, ILN8396GBarnes Greg B · Tunas, MON8396MManley Steven T · Dallas, TXN8396XKnierim Erik E · Puyallup, WAN83971Kepler Jason M · Wasilla, AKN8397BDiaz George D · Tucson, AZN8397JRegistered aircraftN8397TPennsylvania College Of Technology · Williamsport, PAN8397XGeist Jeffrey A · Avondale, PAN8398BThal James C · Fredericktown, MON8398MHale Richard W · Warminster, PAN8398UAdrenaline Junkies LLC · Richfield, UTN8398XCummings Thomas H · Lewistown, MTN83992Mandala Michael L · Chowchilla, CAN8399BHumphrey William J · Whiteville, NCN8399XWard Bruce · Fowlerville, MIN83BSWilliams Rae A · Elmore, ALFirst renewal noticeN83DEVillanueva Ronan Diaz · Jean, NVN83HPPadisak Michael · Traverse City, MIN83HWJohnson Troy A · Greenfield, MON83LWWhitaker David E · Canton, OHN83NStromberg Lee W · Rochester, NHN83XUnger Robert C · Tinley Park, ILN84006Mueller David C · Fremont, NEN8400HSpirit Of Flight Foundation · Nampa, IDN8400JBlue Wings LLC · Brecksville, OHN8400XBurlingame Craig D · Catlett, VAN8401JKingdom Air Corps · Sutton, AKN8401XWilkinson Bert D · Sandpoint, IDN8402MBurke Shawn T · Flowery Branch, GAN8402UWj Rothwell Ranch Co · Hyannis, NEN8402XDominy Geary B · Flint, TXN84031Hamilton James S · Decker, MTN8403UAnderson Larry L · Silver City, NMN8404JMalphurs Larry Neil · Pooler, GAN8404MMitchell Ryan G · Ventura, CAN8404UAviation Career Enrichment Inc · Atlanta, GAN8404XHousel LLC DBA · Palm Harbor, FLN84055Wilkinson Brad · Williamson, GAN84059Lsa Flight LLC · Louisville, KYN84069Kim Jonathan · Abilene, TXN8406UGrzincich Michael J · Coon Rapids, MNN84070Kraft Ag Aviation Inc · Mapleton, NDN8407XDouthett Fontaine · Deland, FLN8408UMastey Patrick R · Saint Cloud, MNN8409GOberholzer Craig C · Stanley, NCN8409XAlbers Stanley F · Hazlet, NJN840BWilkey Ryan J · Saint Louis, MON8410J1st Flight LLC · Allentown, PAN8410MJr Imaging Logistics Inc · Pasco, WA
Back to AD 94-05-05 R1