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.
N1366DOwens Anthony F · Guntersville, ALN1366FBenton Joseph C · Hinckley, MNN1366YTulsa Turbine & Recip Inc · Tulsa, OKN1367FMoehn Dennis H · Oshkosh, WIN1368FAerospace Trust Management LLC Trustee · Wilmington, DEN1368HWestlake Aviation LLC · Seattle, WAN1369DDuckworth Edward I · Liberty, MON1369FHoudelife Aviation LLC · Bixby, OKN1369YMadden James D · Sharpsburg, GAN1371DFrank Taylor Joseph · Tamarac, FLN1371FJones Michael Robert · Glen Rose, TXN1371YFlightsuit Farmer LLC · Imperial, NEN1372BBorden Lance S · Friendswood, TXN1372HNelson Chester C · Little Falls, MNN1373BChaffey George E Trustee · Lafayette, CAN1374BWidman Robert M · Fairbanks, AKN1374FHegge Luke T · Pine City, MNN1374QAdams Robert J · Syracuse, NYN1374YBowden Richard P · Lenexa, KSN1376FWerderich George A · Bartlett, ILN1376HMikos Nicholas J · Anchorage, AKN1376QPaciej Bernard P · Luzerne, PAN1377DJohnson Lawrence F · Anchorage, AKN1377FMartinelli James · Madras, ORN1378DPalmerlee John B · Santa Rosa, CAN1378HPinsky Harold M · Ann Arbor, MIN1378KHebron Jeffrey N · Trenton, SCN1378QOppegard Nicholas · Eagle River, AKN1379DGods Chosen Flyers LLC · Apex, NCN137ECWessel Henry J · Lexington, SCN137ESWhobrey Andrew T · Bee Spring, KYN137SAAlen Sergio Raul · Davie, FLN1381BJames Dennis · Pleasant Grove, CAN1381HSolek Kyle M · Copper Center, AKN1382FCloud 9 Aviation LLC · Scenery Hill, PAN1382KPierce Larry J · Moxee, WAN1382QRegistration Pending · Hubbard, OHRegistration pendingN1384HGoodhue David H · Vancouver, WAN13854Depaoli Mark J · Sacramento, CAN1385FRautio Ian · Intl Falls, MNN1385QRegister Trenton D · Wilmington, NCN1385YCaracci Sam V Jr · Galesburg, ILN1386DDeford Shawn J · Hope, AKN1386QRegistration Pending · Wasilla, AKRegistration pendingN1387FEllis Jerald K · Fort Myers, FLN1387HAbrahamson Joe Trustee · Phoenix, AZFirst renewal noticeN1387QHendricks Adam · Plano, TXN1387YBi-County Ambulance Service Inc · Yuba City, CAN1388BSchmid Nathan J · Wilmington, OHN1388DGroceman Bernard F · Jackson, MO
Back to AD 94-05-05 R1