Registered aircraft · 2,860

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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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.

N492DYLerma Aviation LLC · Dallas, TXBuilt 2001 · S/N 258546 N494GPAerotrust Services Corp Trustee · Wilmington, DEBuilt 1990 · S/N 550-0627 N495CMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1980 · S/N 550-0151 N496JHN496jh LLC · Clovis, NMBuilt 1998 · S/N 560-0496 N497PFBravo Air LLC · Sellersburg, INBuilt 2000 · S/N 550-0964 N499EMPhysicians Air Transport LLC · Hot Springs, ARBuilt 1999 · S/N 550-0869 N499NHHaws Aviation LLC · Huntsville, ALBuilt 1981 · S/N 465-56 N499PANe Charters LLC · South Jordan, UTBuilt 2005 · S/N 258739 N49CTJog001inc · Lewes, DES/N 314 N49DKKts Holdings LLC · Elk Grove Village, ILBuilt 1990 · S/N 560-0075 N49JHWildhorse 340 LLC · Kalispell, MTBuilt 2017 · S/N 525-0959 N49KWJet Air Inc · Iowa City, IABuilt 2002 · S/N 550-1021 N49LDMckee Foods Transporation LLC · Collegedale, TNBuilt 2008 · S/N 560-0803 N49NTCheyenne Aircraft LLC · Searcy, ARBuilt 2024 · S/N 525-1170 N49UN49u LLC · Forest, VABuilt 1979 · S/N 550-0082 N49WLRfs Air LLC · Tucson, AZBuilt 1981 · S/N 457 N4ATGifford David K · Newton, MABuilt 1997 · S/N 550-0805 N4EASaldana Air LLC · Huntley, ILBuilt 1981 · S/N 458 N4TLMorningstar Aviation II Inc · Wilmington, DEBuilt 2001 · S/N 560-0587 N4TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1991 · S/N 560-0105 N4ZLFlying 5 Llcf · Johnson City, TNBuilt 1997 · S/N 560-0448 N500BJAir Metro Leasing Inc · Wilmington, DEBuilt 1978 · S/N 242 N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303 N500FZDb N941jp LLC · Largo, FLBuilt 1989 · S/N 560-0018 N500LLBlackbird Aero LLC · Boca Raton, FLS/N 095 N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323 N500UJMmi Air LLC · Bakersfield, CABuilt 1990 · S/N 560-0062 N500XPHawker 800xp LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258455 N501AKDl Fly LLC · Santa Maria, CABuilt 2009 · S/N 525-0689 N501CJOstrich Boot LLC · Little Rock, ARBuilt 1999 · S/N 525-0355 N501GGN501gg LLC · Pasco, WABuilt 1983 · S/N 550-0484 N501JGChallenger Aircraft Charters LLC · Newport Beach, CABuilt 1996 · S/N 560-0344 N501JVJetvue Texas LLC · Richardson, TXBuilt 1982 · S/N 373 N504CCFirst Port Air Inc · Omaha, NEBuilt 1999 · S/N 560-0504 N504PWide Open Management Services LLC · Winston Salem, NCBuilt 1993 · S/N 525-0026 N504RWYingling Aircraft LLC · Wichita, KSS/N 560-0352 N504USunshine Airways Of N O LLC · New Orleans, LABuilt 2004 · S/N 560-0665 N504WFTito Enterprises LLC · Cameron, MTBuilt 2022 · S/N 525-1118 N505GJMed Air LLC · Wilmington, DEBuilt 1983 · S/N 505 N505MSCessna Aircraft Leasing LLC · Daytona Beach, FLS/N 550-0601 N505RHHondo Aviation LLC · Roswell, NMBuilt 2009 · S/N 560-0813 N505SJMidje LLC · Humboldt, TNBuilt 1994 · S/N 525-0051 N506PDDodson International Parts Inc · Rantoul, KSS/N 550-1084 N506RWPapa Foxtrot Charlie LLC · Atascadero, CABuilt 1994 · S/N 560-0274 N507ECSiilats Keith Trustee · New York, NYS/N 5500143 N507HPCj Capital Partners LLC · Mount Pleasant, SCBuilt 2000 · S/N 525-0395 N507PDGr Aviation LLC · Saint Louis, MOBuilt 2002 · S/N 560-0596 N508KDAero Air Charter Holding LLC · Pensacola, FLBuilt 1991 · S/N 5600147 N508WGJobs Lane Aviation LLC · Englewood Cliffs, NJBuilt 2018 · S/N 525-0982 N508YVDodson International Parts Inc · Rantoul, KSS/N 573

Back to AD 97-05-03 R1