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.
N1454WWeber Jacob H · Hartford, WIN1454YPendergrass Curt E · Saint Petersburg, FLN1455Lenbom Mark A · Cameron, WIN1455BMartin Rand E · Lake Stevens, WAN1455DSherwood Kenneth M · Northville, NYN1455QJackson Scott G · Layton, UTN1455YHelm Richard A · Buckeye, AZN1456BGregory Norbert L · Farmington, MNN1456FBeames Delbert A · Visalia, CAN1456HLafrance Edward J · Ellensburg, WAN1456NGentile Anthony · Madison, ALN1456YLeonardi William J · Jamesport, NYN1457FAdvanced Aviation LLC · Pontiac, MIN1458BPerkins William Barry · Monterey, CAN1458FMaltby Patrick W · Bath, MIN1458NTweety Co LLC · Toledo, OHN1458YTln Aviation LLC · Stanwood, WAN1459BDavis Jeffrey S · Oregon City, ORN1459FGostecnik Gary · Brookshire, TXN1459HLuke Daniel J · Burlington, WIN1459YBriere Mark E · Mims, FLN145EBMorgan Military Aviation Museum · Cameron, TXN145WKBeierman Timothy J · Albion, NEN145WMGwyn Kenneth R · Mount Airy, NCN1460FConrad William A · Freedom, WIN1460HNeeves Aviation And Flying LLC · Sioux Falls, SDN1461QMarquez Christopher D · Fleming Island, FLN1461YKarpov Vladimir · Raymond, NEN1462DWarner Aric D · Rosamond, CAN1462FLambdin Charles Randall · Wolf Lake, ILN1462HParrott David C · Harrison, MEN1463BRegistered aircraftRegistration pendingN1463DSorrell Edward S · Vero Beach, FLN1464HKnight Aaron P · Marion, INN1465DHendrickson Elisabeth · Kerrick, MNN1467BNielsen Jeffrey S · Ashland, ORN1468DAhrens David R · Guthrie Center, IAN1469NCox Natalie · Beach City, TXN146DRInternational Air Services Inc Trustee · Carson City, NVN146FTTavener Frederick L · Cape May, NJN146JHGodinez Mauricio U · San Diego, CAN146VSchmidt Aaron Joseph · Bisbee, AZN146YSHorn George A · Spicewood, TXN1471DSchwarzkopf Michael A · St Peters, MON1471HWestern Antique Aeroplane & Automobile Museum · Hood River, ORN1471QRader Gregory · Baldwin City, KSN1472NPruzek Russell T · New Auburn, WIN1473DDrake Wm Ronald · Marshall, MON1473HMyburgh Hendrik T · Sunnyvale, CAN1473YPetty James F · Crandall, GA
Back to AD 94-05-05 R1