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.
N3195CDarling Jonathan S · Pender, NEN3195NLimpert Theodore H · Syracuse, NYN3196XFroes Carlos Da Lapa · Avondale, AZN3197BLavell Michael J · Blue Mounds, WIN3197XLynn Christopher M · Hood River, ORN3198AAdams Peter B · Anchorage, AKN3198BHerman Timothy R · Presho, SDN3198JAlternate Air Inc · Seattle, WAN3199NMcconnell Sarah C · Shepherd, MTN3199XClark Terry E · Dixon, MON319DDenimarck Vincent · Wildwood, FLN319DSMaxgar Inc · Wilmington, DEN31EREmbry Riddle Aeronautical Univ Inc · Prescott, AZN31FLloyd Land Plane II LLC · Brighton, CON31FCInternational Air Services Inc Trustee · Carson City, NVN31TWHall Wendell W · Cheraw, SCN31WAbell Alan R · Elgin, ILN3200CRegistered aircraftN3200JOdell Steven P · Perrysburg, OHN3200KRock Jeffrey B · Fountain Valley, CAN3201HSale Reported · Miami, FLSale reportedN3201XSale Reported · Glen Allen, VASale reportedN3202LMatta Figueroa Eduardo · Chapman, KSN3203ALowenstein Jeffrey · Juneau, AKN3203EBaker Marty R · Noonan, NDN3204JBecker Charles A · Rice Lake, WIN3204XKulesza Roman · Noblesville, INN3205ARichards Peter C · Poughkeepsie, NYN3205XAvery Jackson R · Ontario, ORN3207KHull Bart D · Laveen, AZN3208JLandon Christopher L · Portland, ORN3208XRhodenbaugh Mitchel D · Wyndmere, NDN3208ZSlinger Charles D · Randolph, WIN3209LPike Alisa · Brooksville, FLN3210KBurrous Peter M · Mount Pleasant, SCN3211AFreeman Varel D · Ocala, FLN3211FJohnson Kenneth E · Sterling, AKN3211HYellow Fly Inc · Lakeland, FLN3211JGo Captain LLC · Lake Worth, FLN3212JBrown Joseph E · Palmdale, CAN3212LBlackstone Rotorcraft Inc · Hartselle, ALN3213ERedmon Ronald D · Crestwood, KYN3213XAlrubaiie Ihssan R · Fort Worth, TXN3214KGadis Anthony J · Etiwanda, CAN3215AHoffmeyer Scott D · Carson City, NVN3215XVoltmer Benjamin P · Excelsior Springs, MON3216VTwo Dot Aircraft LLC · Kalispell, MTN3217JMalinchak Louis Trustee · Bristow, OKN3218KSteinhausen Darrell · Torrington, WYN3219HSerrano Juan Carlos · Buckeye, AZ
Back to AD 94-05-05 R1