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.

N24JDVac Sys Holdings LLC · Roseville, CABuilt 1981 · S/N LA-134 N24KTFalcon Type Air LLC · Nashville, TNBuilt 1995 · S/N 650-7052 N24LKPrime Rib Aviation LLC · Nowata, OKBuilt 1980 · S/N E-1744 N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037 N24QATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 560-0762 N24SAClark Lloyd E · Hanover, MDS/N 24-117 N24SMExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2002 · S/N 258567 N24WXTre Aviation Corp · Wilmington, DEBuilt 1966 · S/N 101 N24XPOlive Organization LLC · El Paso, TXBuilt 2019 · S/N 525-1023 N250ADWings Air LLC · Jackson, TNBuilt 2002 · S/N 560-0605 N250FCKorban Aviation LLC · Mcallen, TXFirst renewal noticeBuilt 1985 · S/N BB1215 N250LHAl Air LLC · Knoxville, TNBuilt 2012 · S/N FL-813 N250MBNo Layover LLC · Hays, KSBuilt 1993 · S/N 258237 N250PKVandelay America LLC · Newport Beach, CABuilt 2001 · S/N 560-0568 N250TMAbd Equipment LLC · Aledo, TXS/N BB822 N250TTLakeside Metal Specialties Inc · Paragould, ARS/N BB1505 N250WGChartco LLC · Salisbury, NCBuilt 2001 · S/N BB-1780 N251AKAlaska Airlines Inc · Seatac, WAS/N 62470 N251CBUsf Management Corp · Tampa, FLBuilt 1979 · S/N 501-0097 N251CFN251cf LLC · Dove Canyon, CABuilt 1983 · S/N BB-1147 N251GMJrjgc Investments LLC · Saltillo, MSBuilt 2015 · S/N 525-0895 N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311 N25201United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28958 N252FLTenax Aerospace LLC · Ridgeland, MSS/N FL-421 N252HRJohnson Breeders Inc · Rose Hill, NCBuilt 1999 · S/N FL-251 N252JKLow Country 525 LLC · Charleston, SCBuilt 1996 · S/N 525-0166 N252RCPrestige Worldwide Flights Two LLC · Imperial, CABuilt 1987 · S/N LJ-1152 N252RVHssj LLC · Chattanooga, TNBuilt 1998 · S/N 5250252 N2531UClyde Shields Entomological Service · Brawley, CAS/N E-2301 N253AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36348 N253CWRegistered aircraftBuilt 1998 · S/N 525-0253 N253GCAerway Capital Management LLC · Waterford, WIS/N 25303 N253GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-253 N253KTInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N E2200 N253TATalon Air Service Inc · Soldotna, AKBuilt 1992 · S/N 20800222 N25466Bas Part Sales LLC · Greeley, COBuilt 1986 · S/N E-2303 N2549625496 LLC · Muscatine, IABuilt 1986 · S/N E-2305 N254DPPulsipher David · Saint George, UTBuilt 1990 · S/N E-2527 N254DRDodson International Parts Inc · Rantoul, KSS/N 560-0607 N254PCAtlantic Wings LLC · New Bern, NCBuilt 1988 · S/N FA-160 N254SBHawker 800xp LLC · Fort Lauderdale, FLBuilt 2003 · S/N 258616 N255BBWright Aviation LLC · Charleston, TNBuilt 2018 · S/N FL-1161 N255GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-255 N255LVN255rv Aviation Corp Inc · Middletown, DES/N 004 N255RVSolomon Mark Trustee · Wilmington, DEBuilt 1983 · S/N 095 N255TTTrident Aircraft Holdings LLC · Nashville, TNBuilt 2002 · S/N BB-1798 N25615Roark Co Inc · Montgomery, ALBuilt 1973 · S/N E-460 N25625Martinez Maurice Dominic · La Habra, CABuilt 1973 · S/N E-393 N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295 N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301

Back to AD 2006-16-18 R1