Registered aircraft · 420

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

N911WNGuardian Flight LLC · Lewisville, TXBuilt 2003 · S/N 525 N913NMSan Juan Regional Medical Center Inc · Farmington, NMBuilt 1997 · S/N 169 N917WWPeregrine Group LLC · Dallas, TXBuilt 2000 · S/N 375 N91BDuck Bill LLC · Athens, GABuilt 1997 · S/N 200 N925HWNorthstar Flying LLC · Fort Lauderdale, FLBuilt 2002 · S/N 444 N928SBBoutique Air Inc · Dallas, TXBuilt 2004 · S/N 552 N92AGKatmai Air LLC · Anchorage, AKBuilt 1999 · S/N 257 N944BTGlobal Aircraft Services LLC · Exeter, CABuilt 2002 · S/N 468 N946JJBetten Equipment Leasing Inc · Grand Haven, MIBuilt 1995 · S/N 115 N950KMMimg Transportation LLC · Franktown, COBuilt 2004 · S/N 540 N954KMKilo Mike Aviation LLC · Fort Lauderdale, FLBuilt 1995 · S/N 114 N956PCAeroshare 2 LLC · Salt Lake City, UTBuilt 2000 · S/N 323 N957STCorporate Fleet Services LLC · Cornelius, NCBuilt 1999 · S/N 295 N95CRCwr Holdings LLC · Wilmington, DEBuilt 2000 · S/N 328 N970NANative Air Services Inc · Greenwood Village, COBuilt 1998 · S/N 226 N977XLStevens Air LLC · Fort Myers, FLBuilt 1997 · S/N 189 N9792Green Mallard Aviation LLC · Wilmington, DEBuilt 1994 · S/N 104 N98WSSilverbird LLC · Reno, NVBuilt 2001 · S/N 435 N991GFGuardian Flight LLC · Lewisville, TXBuilt 2003 · S/N 483 N999EETropacaval Media LLC · Victoria, TXBuilt 2001 · S/N 391

Back to AD 98-11-01 R2