Registered aircraft · 11,798

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

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:2006-16-18-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:2006-16-18-R1') ORDER BY n_number

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N214FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 300 N214GBPterodactyl Inc · Wilmington, DEBuilt 1999 · S/N BB-1668 N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894 N214ML1st Franklin Financial Corp · Toccoa, GAS/N FL-475 N214PNavajo Nation · Window Rock, AZBuilt 1991 · S/N LJ-1293 N214RJJones Larry V · Ocala, FLBuilt 1999 · S/N E3263 N214RSFlying Kw Co · Millsap, TXBuilt 1977 · S/N E-957 N214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CABuilt 1975 · S/N BC-02 N214SCAzul Air LLC · Dover, DEBuilt 1976 · S/N LW-96 N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332 N214TPPlatinum Aviation LLC · Monte Sereno, CAS/N BB1855 N2150HCove Pointe Air LLC · Adrian, MIBuilt 1977 · S/N 210 N2150LB-58 Inc · Albany, GAS/N TH-781 N2159LMark A Smith Airplane Sales Inc · Homosassa, FLBuilt 1976 · S/N E-902 N215AKAlaska Airlines Inc · Seattle, WABuilt 2019 · S/N 36347 N215BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5232 N215BTScreen Star Inc Trustee · Wilmington, DEBuilt 2009 · S/N 20800517 N215HCPlane Lease Co · Minneapolis, MNS/N BB-1848 N215MCTatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1999 · S/N 208B0730 N215MPPersson Timothy J · Kansas City, KSS/N 421C1231 N215NCDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N E-3444 N215RWUnderwood Darin M · Cedar Rapids, IABuilt 1995 · S/N E-2965 N215TPMiddle Tennessee State University · Murfreesboro, TNS/N RJ-64 N215TXTexas Dept Of Public Safety · Austin, TXBuilt 2012 · S/N 20800542 N2163LS & S Southern Group Inc · Port Orange, FLS/N E-903 N2168LRobbins Carl K · Columbia X Rd, PABuilt 1976 · S/N E-905 N216RHannah Ambra · Tucker, GABuilt 1978 · S/N E1341 N216RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0379 N21723United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28790 N217AJMontana Jet LLC · Monterey, CABuilt 2003 · S/N 560-0638 N217ARRgv Sky LLC · Harlingen, TXBuilt 2001 · S/N E-3421 N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621 N217GLBozzy Creek LLC · Frisco, TXBuilt 1990 · S/N 560-0076 N217LGStaggerwing Holdings LLC · Crystal Lake, ILBuilt 1995 · S/N BB-1501 N217LJFessenden Hart W · Port Orange, FLBuilt 2000 · S/N E-3334 N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739 N217PCClearwater Consultants Inc · Starkville, MSBuilt 2000 · S/N E-3330 N217SCJtfs LLC · Huntsville, ALBuilt 1999 · S/N E-3221 N217THDouble I Enterprises LLC · Mcallen, TXBuilt 1996 · S/N 560-0390 N217USDavis Aviation Inc · Brandon, MSBuilt 2007 · S/N FL-519 N2183LDarfus Jason D · Tracy, CABuilt 1976 · S/N E-969 N218CGCourtney Melissa · San Diego, CABuilt 1980 · S/N E-1741 N218DZRed Brick Summit LLC · Wilmington, DEBuilt 1981 · S/N BB-925 N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489 N218GJJaztec LLC · Ooltewah, TNBuilt 1982 · S/N BB-1013 N218JGNoel Edmund O · Houston, TXBuilt 1981 · S/N 5010218 N218LCWright Air Service Inc · Fairbanks, AKBuilt 2018 · S/N 208B5476 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426 N218RXAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1996 · S/N 258323

Back to AD 2006-16-18 R1