Registered aircraft · 26

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:2000-04-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-21') 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:2000-04-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-21')
  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:2000-04-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-21')
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.

N209ECYavapai County · Prescott, AZBuilt 2007 · S/N RN074 N261VSVertol Systems Company Inc · Destin, FLS/N RN061 N266VSVertol Systems Company Inc · Destin, FLBuilt 2002 · S/N RN066 N300FXFxc Nation Leasing LLC · Palm Springs, FLBuilt 2000 · S/N RN056 N3500XHelicopter Flight Services LLC · Groton, SDBuilt 2000 · S/N RN047 N375SDBrown Helicopter Inc · Pensacola, FLS/N RN010 N39GACrosswind Leasing LLC · Prescott, AZBuilt 1998 · S/N RN039 N416MMountain Ridge Helicopters LLC · Murray, UTBuilt 1998 · S/N RN043 N420GCRegistered aircraftBuilt 2005 · S/N RN053 N507CCRotorworks LLC · Hiram, GABuilt 1997 · S/N RN007 N511VAAb Monterrey Aircraft LLC · Newark, DES/N RN023 N555MSAvioelectronica Inc DBA · Coral Springs, FLS/N RN079 N600ESIron Horse Aviation LLC · Newton, IAS/N RN030 N600FTLancair Of Texas DBA · Fort Worth, TXBuilt 2008 · S/N RN077 N600MWSale Reported · West SussexSale reportedBuilt 2001 · S/N RN064 N600NRSharcott Inc Trustee · Wilmington, DEBuilt 2008 · S/N RN073 N609RPRonald A Peterson Inc DBA · Orlando, FLBuilt 1997 · S/N RN009 N60BKBrim Equipment Leasing LLC · Ashland, ORBuilt 1998 · S/N RN028 N630AGLafayette Aircraft Leasing LLC · Fort Lauderdale, FLBuilt 1997 · S/N RN015 N641LBGr (Uk) Inc Trustee · Wilmington, DEBuilt 1998 · S/N RN041 N678SKLga 1992 LLC · Aubrey, TXBuilt 2010 · S/N RN078 N69VSWind River Aviation LLC · Lawton, OKBuilt 2006 · S/N RN069 N70JRAircraft Securities LLC · Wilmington, DEBuilt 1997 · S/N RN014 N745MBCobra Aviation Services LLC · Ashland, ORBuilt 2002 · S/N RN067 N810LACobra Aviation Services LLC · Ashland, ORS/N RN044 N812LHBrim Equipment Leasing LLC DBA · Ashland, ORBuilt 1997 · S/N RN022

Back to AD 2000-04-21