OpenAirDocs.org
AD 97-05-03 R1

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
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.

N560FPEdwards Carl E Jr Trustee · Oklahoma City, OKBuilt 2001 · S/N 560-0566N560FTN560ft LLC · Middletown, DEBuilt 1990 · S/N 5600042N560FWPspb Aviation LLC · Fort Worth, TXBuilt 1991 · S/N 560-0123N560GMachugh David · Pasco, WABuilt 1991 · S/N 560-0112N560GG2141 Corp · Wilmington, DES/N 560-0037N560GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 560-0263N560GTN560gt LLC · Mount Upton, NYBuilt 1996 · S/N 560-0093N560HKa N22cr LLC · Lewes, DEBuilt 2001 · S/N 560-0576N560HLH C E Leasing LLC · Cleveland, TNBuilt 1995 · S/N 560-0341N560HMG Money LLC · Delavan, WIBuilt 2006 · S/N 560-0699N560HSPdm Air LLC · Wilmington, NCBuilt 1996 · S/N 560-0377N560JAJjl Aviation LLC · Springville, IABuilt 1998 · S/N 550-0849N560JDBig Mountain Aviation Inc · Whitefish, MTFirst renewal noticeBuilt 1992 · S/N 560-0174N560JJXcancerair LLC · Omaha, NEBuilt 1997 · S/N 560-0441N560JKCitation Investments LLC · Dallas, TXBuilt 1995 · S/N 560-0284N560JMDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N 560-0010N560JSDouble R Air LLC · Bossier City, LABuilt 1995 · S/N 560-0322N560JW3640 Aviation LLC · Mandeville, LABuilt 2001 · S/N 560-0560N560KHHarrison Aviation LLC · Salem, ORBuilt 1993 · S/N 560-0211N560LFCamelot Express LLC · Roswell, GABuilt 2004 · S/N 560-0662N560LHL&H Sub LLC · Gillette, WYBuilt 2007 · S/N 560-0778N560LTLife Time Inc · Chanhassen, MNBuilt 2000 · S/N 560-0541N560LWLarry Aviation LLC · Richland, WABuilt 1990 · S/N 5600053N560MFMorales J Mark Trustee · Corpus Christi, TXBuilt 1996 · S/N 560-0370N560MGSongbird Aviation LLC · Nashville, TNBuilt 1993 · S/N 560-0223N560MMN2617u LLC · Amarillo, TXBuilt 1993 · S/N 5600228N560MRCitation Associates Inc · New Castle, DEBuilt 2002 · S/N 560-0594N560PAN560pa LLC · Wilmington, DEBuilt 1991 · S/N 560-0136N560PEFortuna Travel Partners LLC · Burbank, CABuilt 1996 · S/N 560-0379N560PHM & S Aviation LLC · Wilmington, DEBuilt 1992 · S/N 560-0199N560PKAncira Autos LLC · San Antonio, TXBuilt 1991 · S/N 560-0133N560PPEncore Aviation Holdings LLC · Jacksonville, FLBuilt 2005 · S/N 560-0687N560PWWintermute Aviation LLC · Westport, CTBuilt 1991 · S/N 560-0101N560PYHardrock Transport LLC · Pulaski, VAS/N 560-0034N560REBlack Diamond Aviation LLC · Dover, DEBuilt 1992 · S/N 560-0156N560RHHarris Air Inc · Logan, UTBuilt 2007 · S/N 560-0773N560RKHoover Cc LLC · Rockport, TXBuilt 1997 · S/N 560-0407N560RMKa LLC · New Paris, INBuilt 2004 · S/N 560-0658N560RRLange Tim R · Corpus Christi, TXS/N 560-0012N560RTBas Part Sales LLC · Greeley, COBuilt 1991 · S/N 5600125N560RWRbw Enterprises Inc · Conshohocken, PAFirst renewal noticeBuilt 1992 · S/N 5600196N560RXHoldco Cv LLC · New York, NYBuilt 1996 · S/N 560-0378N560SAGolden Air Inc · Dover, DEBuilt 2004 · S/N 560-0660N560SMRds Wings LLC · Los Gatos, CABuilt 1989 · S/N 560-0017N560TACu III LLC · Stuart, FLBuilt 1997 · S/N 560-0430N560TLN560tl LLC · Amarillo, TXBuilt 1989 · S/N 560-0423N560TTPresto LLC · Renton, WABuilt 1995 · S/N 560-0293N560TXSav Aviation LLC · Jacksonville, TXBuilt 1996 · S/N 560-0382N560VXVia-560vx LLC · Leawood, KSBuilt 1999 · S/N 560-0512N560WDAbbott Air Inc · Hydro, OKBuilt 2003 · S/N 560-0643
Back to AD 97-05-03 R1