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.
N8410UMcbride Robert D · Buffalo, WYN8410XFondy Investments LLC · Anchorage, AKN84116Koliadko Joseph I · Luray, VAN8411MGroce Austin L · Lebanon, TNN8411UNeu Aviation LLC · Benton, LAN8411XOrr Kent C · Kearney, NEN84120Saylor Kasey · Searcy, ARN8412GMiller Charles V · High Point, NCN8412JMckeon Michael F · Warren, MEN8412U8 For 9 LLC · Scotia, NYN8412XSuttle Joe Albert · Moody, ALN8413JGrimaldos Juan P · Fairbanks, AKN8413XPilot Pros Inc · Miami, FLN84144Grindeland Ethan P · Hatton, NDN8414GKendallville Flying Service Inc · Saint Joe, INN8414JRegistered aircraftN8414UHanan Rose R · Arcata, CAN8414XRps-Lrs Investments Inc · Wilmington, DEN8415Marcy Arthur W · Appleton, WIN8415MMaldonado John F · Santa Fe, NMN8416GMetrovich Paul A · Wellsville, OHN8416MCineflex Inc · Glen Cove, NYN8416UKing J Boyd · Snover, MIN8416XBas Part Sales LLC · Greeley, CON8417UPeninsula Aero Technology Inc · Kenai, AKN8418GBravo Charlie Global LLC · Kalispell, MTN84197Short Michael J · Independence, ORN84199Owen James G · Maynardville, TNN8421Jonsson Erik · Twin Falls, IDN8421USky Falcon LLC · Syracuse, NYN84228Marshall Donald R · Cape Girardeau, MON8422XDundee Flying Club Inc · Rock Stream, NYN8423GCamp Derek E · Sweetwater, TNN84244Campbell Stephen C · Millinocket, MEN8424MSnipes Sandra A · Vandemere, NCN8424XHarvey Barrett K · Robstown, TXN8425GSaitto Jeffrey M · Media, PAN8425XGarzione John E · Sherburne, NYN8427JLee Susan Administrator · San Antonio, TXN8427UCoulombe Michael J · Lunenburg, MAN84286Steffens Gerald J · Seymour, WIN8428GTrainor Ty Anthony · Sneads Ferry, NCN84294Champ294 LLC · Maumelle, ARN8429JRegistration Pending · Cincinnati, OHRegistration pendingN8429MFowler George · Bradenton, FLN8429UHomrich Paul R · Maybee, MIN842BShank Ronald D · Greensburg, KSN842WBGiesbrecht Nolan R · Burns, ORN84306Petes Flight Inc · La Porte, INN8430JBuchinsky Steven · West Plains, MO
Back to AD 94-05-05 R1