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.

N843MLGlobal It Air LLC · Suwanee, GAS/N 550-0953 N844MMGp Aviation LLC · Morristown, NJBuilt 2014 · S/N 525-0844 N845ATApalach Adventures LLC · Chattanooga, TNBuilt 2000 · S/N 560-0547 N845LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 525-1062 N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342 N847TX4 Ms Holding LLC · Spring, TXBuilt 2007 · S/N 258847 N848GAdmin Holdings LLC · Colleyville, TXBuilt 1998 · S/N 560-0465 N848NAsf Aviation LLC · Cortlandt Manor, NYBuilt 1998 · S/N 258371 N84BAA & W Aviation LLC · Lafayette, LABuilt 2007 · S/N 525-0645 N84JGTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 2000 · S/N 258507 N84NRSs Jets LLC · Wildwood, GAS/N 525-1045 N84TJUsaircraft Inc · Newark, DES/N 188 N84UPN84up LLC · Wilmington, DEBuilt 2000 · S/N 258484 N850CCSunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-38 N850DPN850dp LLC · Wilmington, DEBuilt 2000 · S/N 258468 N850ENBcbg Capital LLC · Clearwater, FLBuilt 2002 · S/N 326 N850FBBocre Leasing Inc · Hauppauge, NYBuilt 2004 · S/N 258677 N850FJPachy Music Corp · Bellflower, CABuilt 1991 · S/N 215 N850MACentral Aviation LLC · Sebring, FLBuilt 1999 · S/N 560-0514 N850SXN850sx LLC · Lewes, DEBuilt 1994 · S/N 258270 N850UXHawker Jet Holdings LLC · Opa Locka, FLBuilt 2003 · S/N 258632 N850WGDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 258492 N850XMHawker Jet Holdings Xp1 LLC · Opa Locka, FLS/N 258426 N851BMMorton Transport North LLC · Wilmington, DEBuilt 2005 · S/N 258706 N851DBE-9 Enterprises LLC · Chattanooga, TNBuilt 1994 · S/N 525-0054 N851HSCp Expansion 2 LLC · Little Rock, ARBuilt 2002 · S/N 550-1028 N851LDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1977 · S/N 114 N851RGFirst Equipment Leasing LLC · Fort Lauderdale, FLBuilt 2003 · S/N 258634 N851SHFlight Time LLC · Des Moines, IABuilt 1997 · S/N 560-0439 N852HAAirspeed Aviation LLC · Millersburg, OHBuilt 1980 · S/N 550-0382 N852SHFive Stallions LLC · Valley, NEBuilt 1998 · S/N 560-0476 N853ACSwihart Properties LLC · Roanoke, INBuilt 2007 · S/N 560-0774 N853CRVehicle Holdings Inc · Las Cruces, NMBuilt 1995 · S/N 560-0324 N854JAN854ja LLC · Walterboro, SCBuilt 2000 · S/N 550-0920 N855BBAmador Stage Lines Inc · Sacramento, CABuilt 2000 · S/N 525-0381 N855EDSky Miles LLC · Sioux Falls, SDBuilt 2014 · S/N 525-0850 N855JFg Flight LLC · Sanibel, FLBuilt 2021 · S/N 525-1093 N856ACVision Jet LLC · Fort Wayne, INBuilt 2004 · S/N 560-0656 N857PRTravel Link LLC · Vienna, VAS/N 348 N858AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258731 N858DDDoss Air LLC · Mounds, ILBuilt 1993 · S/N 525-0046 N858DPDgt Aviation LLC · New Bern, NCBuilt 2015 · S/N 525-0896 N858MEFlying Turtles Two LLC · Dallas, TXBuilt 1994 · S/N 560-0253 N858RMPnd Enterprises LLC · Sarasota, FLBuilt 2000 · S/N 550-0914 N858SPBrown Lawson M II · San Diego, CABuilt 1974 · S/N 11 N85EBGt Commercial Interests LLC · Austin, TXBuilt 1998 · S/N 560-0492 N85HEMongoss Inc · Livingston, LABuilt 1980 · S/N 550-0162 N85LXWestern Stage Express LLC · Dubuque, IABuilt 2021 · S/N 525-1085 N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285 N85SCStruthoff Co Inc · San Antonio, TXBuilt 2015 · S/N 525-0898

Back to AD 97-05-03 R1