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.

N2297CRaviator II LLC · Dallas, TXBuilt 1997 · S/N LJ-1497 N2298EUberoy Pawan · Pleasanton, CABuilt 1997 · S/N E3138 N229JSHeritage Of Faith Christian Center DBA · Crowley, TXBuilt 1994 · S/N 560-0255 N229NJbw Aircraft Leasing Co Inc · Seattle, WABuilt 2007 · S/N 560-0759 N229SATwin Otter International Ltd · Las Vegas, NVS/N 468 N229TARemes Stephen · Northfield, MNBuilt 1978 · S/N TH-887 N22AF3l Executive Coach LLC · Duncan, OKBuilt 1991 · S/N 560-0129 N22CPRegistered aircraftBuilt 2003 · S/N 258624 N22ELMustang Jets LLC · Reno, OHBuilt 1977 · S/N 5010045 N22FMjsmm LLC · Santa Rosa Beach, FLS/N BB-1025 N22GSGbs Aviation LLC · Fort Worth, TXBuilt 2001 · S/N BB-1767 N22KWFinn Capital LLC · San Mateo, CABuilt 2015 · S/N 208B5210 N22MTHagler Air LLC · Augusta, GABuilt 1994 · S/N LJ-1368 N22NDynamic Avlease Inc · Bridgewater, VABuilt 1973 · S/N LW48 N22PEAdamb200 Holdings LLC · Broken Bow, OKBuilt 1994 · S/N BB-1488 N22SDodson International Parts Inc · Rantoul, KSBuilt 2014 · S/N 525-0842 N22TENv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2007 · S/N 208B1266 N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826 N22VRHot Rock LLC · Dover, DEBuilt 2016 · S/N FL-1074 N22W22w LLC · Tacoma, WABuilt 2020 · S/N 208B5614 N22WSJ M Mcleod Farms LLC · Carthage, NCBuilt 1979 · S/N E-1506 N22ZV2 Blondes On Board LLC · Brenham, TXBuilt 1979 · S/N E-1570 N2302CDuck & Goose Aviation Inc · St Simons Island, GABuilt 1997 · S/N E-3102 N2303VFindlay Fly Boys LLC · Findlay, OHBuilt 1998 · S/N E-3168 N2307CStuffmann Eric S · Orinda, CABuilt 1997 · S/N E-3107 N230EASea Hawk Airways LLC · Largo, FLS/N E-3530 N230JKBcrc Air LLC · Austin, TXBuilt 2003 · S/N 560-0647 N230MWGot Wings LLC · Woodbury, NYS/N 421C0671 N2311VB & L Henry LLC · Chipley, FLBuilt 1997 · S/N E-3111 N2316National Nuclear Security Administration · North Las Vegas, NVBuilt 2019 · S/N FL-1191 N2317National Nuclear Security Administration · North Las Vegas, NVBuilt 2019 · S/N FL-1192 N2317SSokoloff James T · Cambridge, MAS/N E-3117 N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164 N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118 N2319National Nuclear Security Administration · Las Vegas, NVBuilt 2019 · S/N FL-1190 N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696 N231YVAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-231 N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187 N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124 N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165 N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127 N2329FFlorida Aeronautical Survey Technologies · Fort Lauderdale, FLBuilt 2011 · S/N 208B2312 N232BWNoram Aviation LLC · Tulsa, OKBuilt 2022 · S/N 525-1109 N232CEN232ce LLC · Newberry, FLBuilt 1984 · S/N 650-0067 N232FXAvp II LLC · Winnetka, ILBuilt 1993 · S/N E-2772 N232TAAviation Trading Partners LLC · Shawnee, KSS/N 650-0128 N232WVLewis And Clark Adventures LLC · Lewes, DEBuilt 1994 · S/N E-2906 N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2333VTytan Holdings LLC · Kalispell, MTBuilt 1998 · S/N E-3183

Back to AD 2006-16-18 R1