Registered aircraft · 2,862

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.

N711XSSteiner Gp LLC · Weatherford, TXBuilt 2004 · S/N 560-0678 N712BDBravo Delta Holdings LLC · Austin, TXBuilt 2002 · S/N 550-1025 N713WLOx Aviation LLC · Lewes, DEBuilt 2008 · S/N 560-0798 N714DSPhoenix Air Group Inc · Cartersville, GAS/N 488 N714LMR & B Aviation LLC · Columbia, MOBuilt 2023 · S/N 525-1139 N715JCFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 99 N715LALongbow Aviation LLC · Fernandina Beach, FLBuilt 1999 · S/N 258441 N716BRTiburon Aviation II LLC · Dallas, TXBuilt 1996 · S/N 560-0355 N716DBCervenka Debra A · Santa Rosa Beach, FLBuilt 2002 · S/N 258568 N716DJN716dj LLC · Kentwood, MIBuilt 2021 · S/N 525-1087 N716SNsa II LLC · Frankfort, NYBuilt 1998 · S/N 560-0473 N717AJKalitta Charters LLC · Ypsilanti, MIS/N 183 N717BRSemper Fi Aviation LLC · Aledo, TXBuilt 2020 · S/N 525-1055 N717CBPhysicians Air Transport LLC · Hot Springs, ARBuilt 1998 · S/N 550-0830 N717CHAviation Trading Partners LLC · Shawnee, KSBuilt 1997 · S/N 550-0825 N717DBlountville Aviation LLC · Blountville, TNBuilt 1994 · S/N 5600275 N717DHDarkhorse Aviation LLC · Georgetown, TXBuilt 1990 · S/N 226 N717KVN717kv LLC · Wilmington, DEBuilt 1999 · S/N 258449 N717LFOnpoint Avionics LLC · Downey, CAFirst renewal noticeS/N 32 N717TRTrue Airspeed LLC · Pace, FLFirst renewal noticeBuilt 1982 · S/N 550-0436 N717VLRebus III LLC · Owasso, OKBuilt 2008 · S/N 560-0788 N718RRMac 800xp LLC · Wilmington, DEBuilt 1999 · S/N 258428 N719CACentral Airlines Inc · Leawood, KSBuilt 1979 · S/N 251 N719HGFlightworks Inc · Kennesaw, GABuilt 2000 · S/N 258488 N719RM3v LLC · Yalesville, CTBuilt 1991 · S/N 560-0092 N719WRBroadband Of Indiana LLC · Owensboro, KYBuilt 1999 · S/N 550-0897 N71AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 258654 N71FBTelling Frederick W · Port Orange, FLFirst renewal noticeBuilt 2013 · S/N 525-0812 N71MSkyview LLC · Wilmington, DEBuilt 1976 · S/N 88 N71PPRoberts Motor Company LLC · Amarillo, TXBuilt 1989 · S/N 560-0007 N71RARoyal Air Freight Inc · Waterford, MIS/N 096 N71SYSilver Wing At Sandpoint LLC · Torrance, CABuilt 2014 · S/N 525-0831 N720RCRosado Aviaton Inc · Scranton, PABuilt 2007 · S/N 525-0638 N720WWWilcom Inc · Scottsdale, AZBuilt 1979 · S/N 254 N721BCJh Aircraft Services LLC · Dover, DEBuilt 1990 · S/N 560-0044 N721CFCalspan Corp · Buffalo, NYBuilt 1984 · S/N 429 N721CNUnited Trading Unlimited LLC · Coconut Grove, FLS/N 206 N721ECRegistered aircraftBuilt 1980 · S/N 355 N721NBOneonta Trading Corp · Wenatchee, WABuilt 2004 · S/N 560-0659 N721TFfm LLC · El Paso, TXBuilt 2001 · S/N 5500993 N722CVMile High 5280 LLC · Goldsboro, NCBuilt 1999 · S/N 550-0863 N722SGDt Air LLC · Eden, NCBuilt 1995 · S/N 525-0088 N723NCC&N Aviation LLC · Tucson, AZBuilt 2021 · S/N 525-1070 N723TABank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 560-0783 N724JLAmeri Hawk Investments LLC · Lorton, VABuilt 2006 · S/N 258772 N725CCFlight Oklahoma City Air LLC · Oklahoma City, OKBuilt 1993 · S/N 550-0725 N725CGWest Spark & Fly LLC · Seminole, TXBuilt 2015 · S/N 525-0869 N725CJClub Jet Investments LLC · Wilmington, DEBuilt 1974 · S/N 25 N725DMRhc Logistics Corp · Fostoria, OHFirst renewal noticeBuilt 1997 · S/N 263 N725DSData Sales Co Inc · Burnsville, MNBuilt 1997 · S/N 550-0822

Back to AD 97-05-03 R1