Registered aircraft · 1,017

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-01-11-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-01-11-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-01-11-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-01-11-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-01-11-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-01-11-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.

N327WLSouth Aero Inc · Albuquerque, NMBuilt 1996 · S/N 208B0547 N328JKJk Aviation Venture LLC · Windermere, FLBuilt 2026 · S/N 208B5957 N32ELCoastal Air LLC · Naknek, AKBuilt 2002 · S/N 208B0960 N32NHIsr Platforms LLC · Mclean, VABuilt 2017 · S/N 208B5360 N32WAWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0234 N331RFRandigo LLC · Wilmington, DEBuilt 1999 · S/N 208B0754 N333LDKickin Tires Aviation LLC · Lake Wales, FLS/N 20800530 N336JPKalinin Partners LLC · Juneau, AKBuilt 2013 · S/N 208B5036 N339TAFloatsix Leasing LLC · Lubbock, TXBuilt 2015 · S/N 208B5179 N33NHIsr Platforms LLC · Tysons, VABuilt 2019 · S/N 208B5535 N33TSDevco Properties IV LLC · Louisville, KYBuilt 2019 · S/N 208B5536 N342FAJb Aircraft LLC · Anchorage, AKBuilt 2010 · S/N 208B2162 N347KAKamaka Air LLC · Honolulu, HIBuilt 2012 · S/N 208B2407 N351CCSeamour Express LLC · Coral Gables, FLBuilt 2012 · S/N 208B2351 N376JXAircraft Structures International Corp · Enid, OKS/N 208B0748 N377TASeven Tango Alpha LLC · Ft Lauderdale, FLS/N 208B5123 N379BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20800414 N379DWAircraft Structures International Corp · Enid, OKS/N 208B-0699 N37JWNetwork Sales & Leasing Inc · Newtown, PABuilt 2012 · S/N 208B5001 N381TAHigher4hire LLC · Miami Beach, FLBuilt 2018 · S/N 208B5434 N382TASeaplane LLC · Fort Lauderdale, FLBuilt 2018 · S/N 208B5430 N383TAFloatsix Leasing LLC · Lubbock, TXBuilt 2017 · S/N 208B5343 N384TAFour Tango Alpha LLC · Anchorage, AKBuilt 2016 · S/N 208B5300 N386ARRustic Corp · Fort Worth, TXBuilt 1999 · S/N 208B0787 N387TPEtpc Aviation LLC · Atlanta, GABuilt 2019 · S/N 208B5539 N388TAFloatsix Leasing LLC · Lubbock, TXBuilt 2014 · S/N 208B5127 N394SFCity Wings Inc · St Thomas, VIBuilt 2005 · S/N 20800394 N394SMMission Aviation Fellowship · Nampa, IDBuilt 2023 · S/N 208B5739 N3963CRoberts Aviation LLC · Acworth, GABuilt 2019 · S/N 208B5524 N398AStr Holdings LLC · Lafayette, INBuilt 1994 · S/N 208B0390 N399TTJuliet Foxtrot LLC · Youngstown, NYBuilt 1986 · S/N 20800099 N3LGTuthill James G Jr · Burr Ridge, ILBuilt 2011 · S/N 20800525 N3TCKauai Farms Aviation LLC · Kapaa, HIBuilt 2011 · S/N 20800527 N401SUnderhill Holdings LLC · East Haven, CTBuilt 2015 · S/N 208B5261 N404BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5228 N404SFCity Wings Inc · St Thomas, VIBuilt 2007 · S/N 20800404 N405BSilver Mountain LLC · Port Alsworth, AKBuilt 2024 · S/N 208B5837 N405GVAmpaire Inc · Long Beach, CABuilt 2001 · S/N 208B0892 N406MSilver Mountain LLC · Port Alsworth, AKBuilt 2019 · S/N 208B5558 N407GVPa1 208b-0616 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0616 N409GVPa1 208b-1110 LLC · Fort Lauderdale, FLBuilt 2005 · S/N 208B1110 N409MNBohlke LLC · Kingshill, VIBuilt 2000 · S/N 208B0846 N409MSSale Reported · Nad Ap ShebaSale reportedBuilt 2020 · S/N 208B5578 N40EAEagle Air Transport Inc · Ottawa, ILBuilt 1992 · S/N 20800084 N40JFIsr Aviation LLC · Wilmington, DEBuilt 1994 · S/N 208B0394 N40NERedding Aero Enterprises Inc · Redding, CABuilt 2000 · S/N 208B0874 N410BMMottair LLC · Cincinnati, OHBuilt 2017 · S/N 208B5412 N410GVPa1 208b-0632 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0632 N4118KSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1283 N411GVPa1 208b-0672 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0672

Back to AD 2006-01-11 R1