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.

N64DHSunshine Aero Industries Inc · Crestview, FLBuilt 1965 · S/N 282-52 N64FSJetvue Texas LLC · Richardson, TXBuilt 1984 · S/N 417 N64FTTennison Bryan · Aledo, TXBuilt 1991 · S/N 5600142 N64HAJoe Air LLC · Sellersburg, INBuilt 1999 · S/N 258448 N64LVDitch Diggers Aviation LLC · Lisle, ILBuilt 1996 · S/N 560-0345 N64RT64rt LLC · Birmingham, ALBuilt 1998 · S/N 550-0840 N64SVR S & I Inc · Idaho Falls, IDBuilt 2007 · S/N 560-0764 N64TFParatus Jets LLC · Auburn, INS/N 550-0064 N650CMYc Equipment Co LLC · Orangeburg, SCBuilt 1992 · S/N 560-0177 N650CWTrec Investments LLC · Columbia, MOBuilt 2023 · S/N 525-1153 N650NVNion LLC · New Century, KSBuilt 1997 · S/N 560-0429 N651CJWpi Equipment LLC · Baker City, ORBuilt 2000 · S/N 525-0365 N651MKMaxfly Aviation Inc · Fort Lauderdale, FLBuilt 1981 · S/N 465-73 N652SJVddcpj Inc · Riverside, CABuilt 2004 · S/N 560-0652 N653FJDwts LLC · Powder Springs, GAS/N 110 N654WWLvp Air LLC · Chattanooga, TNBuilt 1994 · S/N 525-0053 N654YSRegistered aircraftBuilt 1981 · S/N 465-60 N655CKArrowhead Aviation Inc · Batesville, ARBuilt 2001 · S/N 525-0448 N655JHTrine Aerospace LLC · Colorado Springs, COBuilt 1990 · S/N 655 N655JSKinsey James Dale · Lubbock, TXBuilt 1992 · S/N 5600190 N655MDMargarita Flights LLC · Longwood, FLBuilt 2004 · S/N 258655 N655MMBem Flight Deck LLC · Wilmington, DEBuilt 1993 · S/N 5500720 N655PEDunbar Aviation LLC · West Kingston, RIBuilt 1982 · S/N 199 N656JG425sr LLC · Hallettsville, TXBuilt 1995 · S/N 560-0298 N656PSCalifornia Oregon Broadcasting Inc · Medford, ORBuilt 1978 · S/N 550-0009 N657DMHamburg Aero Leasing LLC · Hamburg, NYBuilt 2009 · S/N 560-0810 N659WGBuds Tn LLC · Lexington, KYBuilt 2018 · S/N 525-1002 N65BTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 465-3 N65CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 560-0455 N65DVLone Star Ag · Texico, NMBuilt 1989 · S/N 550-0624 N65FFN65ff LLC · Liverpool, NYBuilt 1988 · S/N 550-0585 N65MLBae Systems Technology Solutions & Services Inc · Mojave, CABuilt 1981 · S/N 465-69 N65RLLevi Ray & Shoup Inc · Springfield, ILBuilt 1992 · S/N 560-0179 N661BPBlack Potato Express LLC · Bakersfield, CABuilt 2014 · S/N 525-0832 N662CBGold Dust Potato Processors Inc · Malin, ORBuilt 2003 · S/N 550-1062 N663TWButler National Inc · New Century, KSBuilt 1990 · S/N 35A-662 N664CEPride Aviation Support LLC · Exeter, PABuilt 2004 · S/N 560-0664 N665RCDouble Aught Dairy LLC · Dexter, NMBuilt 2025 · S/N 525-1192 N667WJConnell Blue LLC · Berkeley Heights, NJBuilt 2004 · S/N 258667 N667XLAircraft Leasing And Sales Inc · Wichita, KSBuilt 2006 · S/N 560-5667 N668AJMt Equipment LLC · Sarasota, FLBuilt 1982 · S/N 550-0442 N668CBVolunteer Corp · Clarksville, TNS/N 550-1068 N668EEFlying Journey LLC · El Monte, CABuilt 1999 · S/N 525-0343 N669RARoyal Air Freight Inc · Waterford, MIS/N 669 N66GESunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-28 N66MCDodson International Parts Inc · Rantoul, KSS/N 550-0239 N66MQBravo Partners LLC · Wilmington, DEBuilt 2000 · S/N 550-0913 N66PFWorldwide Option LLC · Lewes, DEBuilt 1998 · S/N 550-0860 N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375 N66ZBCharter Equipment Leasing LLC · Bellevue, WABuilt 2004 · S/N 258675

Back to AD 97-05-03 R1