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.
N9396BRhyshek John C · King Salmon, AKN9396UMullen Randy R · Pasco, WAN93975Alki Investments LLC · Texarkana, TXN93977Hardin Melissa K · Terrell, TXN93978Coleman Stanley · Lefors, TXN9398BBishop Daniel R · Bettendorf, IAN9398UShouling & Philip Enterprise · Lancaster, CAN93997Registration Pending · Maud, TXRegistration pendingN9399BSamoilenko Sergey V · Hillsborough, NCN93ACGwidt Mitchell A · Prior Lake, MNN93DHHowell Robert R · Byron, CAN93JTO Flanagan Clancy H · Chowchilla, CAN93LWDempsey Brian L · Millersville, MDN93PSVanderflute Scott L · Lakewood, WAN93TPBagley Corydon S · Holladay, UTN94002Yogini Modi · Homestead, FLN94003Boggs Marty N · Thomasville, NCN94007Gregory Vernon L · Swansea, SCN9401ASwinney Vincent F · Waldport, ORN94027Killgore Tommie D · Ramer, TNN9402UMayrant Dawson Z · College Station, TXN94039Antonelli Michael · Mesa, AZN9403AJ & K Flying LLC · Marengo, OHN9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeN94040Magnolia Aviation Solutions LLC · Sheridan, WYN9404AMorrison Mark C · Marfa, TXN9404BRutledge Dianna G · Winder, GAN9404UWhitcomb James F · West Ossipee, NHN9405ACronin John W Jr · Denver, CON9405UBishop Michael E · Clarkston, WAN9406AStowell Colt M · Homedale, IDN9406UMontgomery Paul Richard · Fredericksburg, VAN9408ADill Steven S · Hesperia, CAN9408UTenhoff Lee L · Homer, AKN94096Still John D · Greenwood, SCN94099Tr Pegasus Inc · Glenwood, NJN9409UFree Wade · Sharon, OKN9410AAllen Dennis R · San Mateo, CAN94114Sprunger Gary E · Saint Joseph, MIN9411ARenkenberger James H · Saint Joe, INN94129Westall Melina Joan · Anchorage, AKN9412AKrause Victor A · Geneva, ILN9412UGoshev Daniel Mihaylov · Gaithersburg, MDN94131Gregory Vernon L · Swansea, SCN94135Flying Wrenches · Buhl, IDN94145Smith Dwight S · Ann Arbor, MIN9415AMiller Gerald R · Sevierville, TNFirst renewal noticeN94161Sale Reported · Crystal, MNSale reportedN9416BIsler Norman P · Brockport, NYN94171Tittle James L · Pembine, WI
Back to AD 94-05-05 R1