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.
N5403QAbriam Darryl · Dahlgren, VAN5403RPeterson Matthew · Overland Park, KSN5403TIngrim William Paul · Girdwood, AKN5404RKoller Rex E · Athens, ALN5404TCorrea Ruben D · Horn Lake, MSN5405CRegistered aircraftN5405RPolson Taylor M · Killeen, TXN5405TAgt Tech Corp · Hialeah, FLNon-citizen corporation, flight hours not reportedN5406CGugel Joseph J · Wasilla, AKN5406RMmm Enterprises LLC · Aurora, INN5407QR G V Flight Academy LLC · Bayview, TXN5407RLake Area Technical College · Watertown, SDN5409QOwens Anthony G · Kotzebue, AKN5409TSchein Joshua A · Anchorage, AKN540DHoopes Kristopher · Davis, OKN540RWWilkins Rondal · Riverside, CAN5410RIsbell Thomas · Mountain View, ARN5411TTioga Land Development LLC · Tioga, NDN5412QWilson William W · Mccall, IDN5412RYoungstown Warren Development Partners · Youngstown, OHN5412TBartlomiej Gadaj · Jacksonville, FLN5413HLittlefield Keith A · Kent, WAN5413RMckee Thomas E · Terra Alta, WVN5413TLrp Aircraft LLC · Durham, NCN5414CPeachey Daryl J · Belleville, PAN5415CAom Aircraft LLC · Wilmington, DEN5415HHill Ross E · Onida, SDN5415QBrown James Jr · White Hall, ARN5415TStill Flying LLC · Gibsland, LAN5416CHarper Jason Prentis · Oak Grove, LAN5416QSharp Jacob T · Frankfort, KYN5417HCtc LLC · Anchorage, AKN5417RBuenting John E · Sylva, NCN5418TFoster Chad DBA · Theodore, ALN5419TGregorski Thomas E · Kenly, NCN541CPBig T Aviation LLC · Wilmington, DEN541RMontano Roman · Great Barrington, MAN5420ECrowder John T · Summerfield, FLN5420RBarrientos Sebastian · Tamarac, FLN5421HGriffing Lee · Port Clinton, OHN5421RAviation Design LLC · Kalamazoo, MIN5422CBelleau James R · Greeley, CON5422HValburg William · Draper, SDN5422RRice Robert M · Huntsville, ALN5422TShrader Kevin M · Browns Valley, CAN5423HAndersen Michael A · Minot, NDN5424HSlayden Steven M · Rhome, TXN5424TEshleman James E · Yucaipa, CAN5425HSanders Ronald J · Richland, MTN5425RWalker Lyle P · Katy, TX
Back to AD 94-05-05 R1