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.

N208AVTeton Leasing LLC · Pocatello, IDBuilt 1996 · S/N 560-0358 N208AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 208B0710 N208BMerlin Labs Inc · Boston, MABuilt 2003 · S/N 208B1023 N208BABoeing Co · Renton, WABuilt 2008 · S/N 208B2027 N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89 N208BKTwo O Eight LLC · Nantucket, MABuilt 2006 · S/N 208B1190 N208BLCaravan International Leasing Inc · Carson City, NVBuilt 1989 · S/N 208B0182 N208BVRegistered aircraftBuilt 2001 · S/N 208B0913 N208BXBoeing Co · Renton, WABuilt 2011 · S/N 208B2292 N208CEArctic One LLC · Fairbanks, AKBuilt 1995 · S/N 208B0466 N208CNChurchill Navigation Inc DBA · Boulder, COBuilt 2017 · S/N 208B5415 N208CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 208B5253 N208CVKangaru Enterprises LLC · Solvang, CABuilt 2008 · S/N 208B2024 N208DEEvans David J · Parker, COBuilt 1996 · S/N 208B0502 N208DHAcme Prevost LLC · Missoula, MTFirst renewal noticeBuilt 2008 · S/N 208B2018 N208DZSeattle Aircraft Rentals LLC · Bellevue, WABuilt 1998 · S/N 208B0717 N208EDesevarg Inc · Appleton, WIBuilt 2022 · S/N 208B5696 N208EBUS Government · Washington, DCBuilt 2004 · S/N 208B1047 N208EEN208ee Inc · Addison, TXBuilt 2006 · S/N 208B1213 N208EKTechnical Applications & Consulting LLC · Topeka, KSBuilt 2003 · S/N 208B1015 N208EMGlobal Automation Solutions Inc · Marlborough, CTBuilt 2009 · S/N 208B2100 N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N208GSouth Aero Inc · Albuquerque, NMBuilt 2002 · S/N 208B0940 N208GERedemption Incorporated · Kodiak, AKBuilt 1986 · S/N 20800062 N208HFStart Skydiving LLC · Middletown, OHBuilt 1987 · S/N 20800116 N208HWRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0118 N208JANv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1997 · S/N 20800269 N208JBBimini Air LLC · Scottsdale, AZBuilt 2009 · S/N 20800516 N208JGDue-Mor Air LLC · Junction City, ORBuilt 2006 · S/N 208B1232 N208JHWatermakers Air Inc · Fort Lauderdale, FLBuilt 2005 · S/N 208B1144 N208JJPuerto Rico Land And Fruit Se · San Juan, PRBuilt 2022 · S/N 208B5666 N208JKBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1998 · S/N 20800281 N208JPRad Aviation LLC · Wilmington, DES/N 20800362 N208JWFayard Enteprrises LLC · Wake Forest, NCBuilt 1986 · S/N 20800166 N208KABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B5042 N208KGAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 2000 · S/N 20800323 N208KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20800545 N208KREcho Matrix LLC · Bentonville, ARFirst renewal noticeBuilt 1999 · S/N 208-00304 N208KTAircraft Structures International Corp · Enid, OKBuilt 1991 · S/N 208B0258 N208LBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 20800378 N208LNKachemak Bay Flying Service Inc · Huntsville, ALBuilt 2017 · S/N 208B5413 N208LSLife South Community Blood Centers Inc · Gainesville, FLBuilt 2010 · S/N 208B2256 N208MGIsr Platforms LLC · Mclean, VABuilt 2014 · S/N 208B5162 N208MQCountry Flyin Inc · Homestead, FLBuilt 1999 · S/N 208B0771 N208MWMetropolitan Water District Of Southern California · Los Angeles, CABuilt 2015 · S/N 20800572 N208NRNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2005 · S/N 208B1126 N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626 N208PCPlane Fun Inc Tr Trustee · Snellville, GAS/N 208B0986 N208PERc Aviation Services Inc · San Juan, PRS/N 208B5357 N208PGRedding Aero Enterprises Inc · Redding, CABuilt 1999 · S/N 208B-0799

Back to AD 2006-16-18 R1