OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,861

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.

N21HBN44af LLC · Wilmington, DEBuilt 2001 · S/N 560-0590N21HRJetsteam Aviation Inc · Cheyenne, WYRegistration ineffective or invalidBuilt 1981 · S/N 335N21LGTag Air LLC · Fort Worth, TXBuilt 1992 · S/N 5600197N21LMN21lm LLC · Dover, DES/N 560-0117N21SLIoga LLC · Douglasville, GABuilt 1999 · S/N 550-0877N21TKMtk Leasing LLC · Woodburn, ORS/N 525-0131N21TVEffaircy Aviation LLC · Huntsville, ALBuilt 1995 · S/N 560-0337N21UAAbercorn Services LLC · Wilmington, DEBuilt 1982 · S/N 550-0356N21VCCitation Hawk LLC · Moody, ALBuilt 1995 · S/N 525-0106N21VNC2d LLC · Wilmington, DEBuilt 1985 · S/N 35A-560N220CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 120N220CVDodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 220N220JJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 258475N220JLJuliet Charlie LLC · Wolf Creek, MTS/N 525-0020N220PFExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 258542N220SCTbc Aviation LLC · Emporia, KSBuilt 1995 · S/N 560-0326N221Ambrose Consulting Corp · Bellevue, WABuilt 2002 · S/N 560-0626N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320N222DAThane Scott G · Odessa, TXBuilt 1992 · S/N 5600202N222JMOld Well Aviation LLC · Charlotte, NCBuilt 1995 · S/N 525-0116N222MULanier Air East Coast LLC · Pineville, NCBuilt 1980 · S/N 164N222PBBlanchard Aviation LLC · Albuquerque, NMBuilt 1999 · S/N 258443N222TCCase Coal Sales LLC · Louisa, KYBuilt 2017 · S/N 525-0960N223CFCbel Aviation Inc · Macon, GABuilt 2000 · S/N 525-0403N223JFJettair LLC · Dallas, TXBuilt 1997 · S/N 525-0223N223JVJog060 Holdings Inc · Lewes, DEBuilt 1991 · S/N 5600131N223LCLnc Holdings LLC · Billings, MTS/N 550-0183N224CJEagle Aviation LLC · Hamel, MNBuilt 1997 · S/N 525-0224N224GFShamrock Kelly Energy Inc · Blanco, TXS/N 402N224GPKen Lawler Builders Inc · Shreveport, LAS/N 560-0108N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279N225BSHsr General LLC · Weatherford, TXBuilt 2002 · S/N 560-0631N225HAAircraft Fidelity Corp Trustee · Dover, DEBuilt 1979 · S/N 550-0089N226CVMassie G2 LLC · Rocklin, CABuilt 1993 · S/N 560-0226N226PCWhite Oak Flight Service Inc · Beckley, WVBuilt 1998 · S/N 550-0835N227LAK&A Advisors LLC · Wilmington, DEBuilt 1976 · S/N 193N228PGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 560-0310N229BMCessna Aircraft Leasing LLC · Daytona Beach, FLS/N 5500207N229DN229d LLC · Stuart, FLBuilt 1985 · S/N 427N229JSHeritage Of Faith Christian Center DBA · Crowley, TXBuilt 1994 · S/N 560-0255N229NJbw Aircraft Leasing Co Inc · Seattle, WABuilt 2007 · S/N 560-0759N22AF3l Executive Coach LLC · Duncan, OKBuilt 1991 · S/N 560-0129N22CPRegistered aircraftBuilt 2003 · S/N 258624N22GFBravo Sz LLC · Alpharetta, GAS/N 550-1077N22GRM/V Forger Inc · Salem, ORBuilt 1999 · S/N 550-0892N22JAJet Air Inc · Iowa City, IAS/N 550-1129N22PCFlying Falcons LLC · Wilmington, DEBuilt 1988 · S/N 550-0583N22SDodson International Parts Inc · Rantoul, KSBuilt 2014 · S/N 525-0842N230JKBcrc Air LLC · Austin, TXBuilt 2003 · S/N 560-0647N232BWNoram Aviation LLC · Tulsa, OKBuilt 2022 · S/N 525-1109
Back to AD 97-05-03 R1