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.

N356BRBdp Airways LLC · Dover, DEBuilt 1982 · S/N 356N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373N356SAJmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 1994 · S/N 560-0256N357BERegistered aircraftBuilt 2004 · S/N 560-0663N357CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 323N357LJJet Rescue USA Inc · Boca Raton, FLS/N 357N358CKAirnet II LLC · Columbus, OHBuilt 1978 · S/N 210N358CYBondio LLC · Great Neck, NYS/N 358N358HAElsy Equipment LLC · Owasso, OKBuilt 1999 · S/N 525-0358N359CKAirnet II LLC · Columbus, OHBuilt 1979 · S/N 230N35AEAmerican Fidelity Corp Trustee · Dover, DES/N 595N35AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 010N35CDCoastal Development Group LLC · Boca Grande, FLBuilt 1989 · S/N 224N35JXAc Holdings II Inc · Lewes, DES/N D754N35LJDelta Bravo LLC · Taylorville, ILBuilt 1979 · S/N 240N35VTGeneral Aviation Modifications Inc · Ada, OKS/N D-696N35WB253217 Corp · Sumas, WAS/N 350N35WLKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438N360SHRkjm LLC · Superior, NEBuilt 1997 · S/N 525-0201N3616Carter Machinery Co Inc · Salem, VABuilt 2001 · S/N 560-0571N361CAN361ca LLC · Wilmington, DEBuilt 2005 · S/N 258734N361LABest Friends Air LLC · Kerrville, TXBuilt 2001 · S/N 258562N362PTN378c LLC · Parker, COS/N 73N363Tolen Dave · Gallatin, MOS/N D-252N363BSMjti LLC · Santa Rosa, CABuilt 2017 · S/N 525-0961N363CAAlpha Mike Aviation LLC · Murfreesboro, TNBuilt 2002 · S/N 550-1009N364CLLacy Clay Trustee · Los Angeles, CABuilt 1981 · S/N 383N364PKSky Hawk LLC · Moody, ALBuilt 1999 · S/N 525-0320N365EARubi Aviation Inc · Dallas, TXBuilt 1991 · S/N 560-0107N365SMIntegrated Transportation Services LLC · Tupelo, MSBuilt 2007 · S/N 525-0658N365SNNice Neighbors LLC · Wilmington, NCBuilt 1996 · S/N 525-0121N365WACrossland Air LLC · Bentonville, ARBuilt 1981 · S/N 550-0333N367DAGlobal Aviation Inc · Hillsboro, ORS/N 599N367JCWalter Oil & Gas Corp · Houston, TXS/N 560-0069N367WWVmrfalcon50 LLC · Evans, GAS/N 367N368BEDos Amigos Transport LLC · Austin, TXBuilt 2000 · S/N 560-0546N368HSTaylor Aviation LLC · Virginia Beach, VABuilt 1999 · S/N 550-0889N369LSLonestar Aviators LLC · Houston, TXBuilt 1990 · S/N 560-0084N36CPTitan Aviation LLC · Wilmington, DEBuilt 2004 · S/N 5600654N36DZSmb Giii LLC · Longwood, FLBuilt 1984 · S/N 450N36PTMadix Inc · Terrell, TXBuilt 2001 · S/N 550-0966N36RGJrb Of Montana LLC · Wooster, OHBuilt 1996 · S/N 525-0139N36SPKentucky State Police · Frankfort, KYBuilt 1985 · S/N 577N36TXFrog Air LLC · Amarillo, TXBuilt 1996 · S/N 525-0153N3703NGreystone Enterprises Inc · Oklahoma City, OKBuilt 1947 · S/N D-909N3705NRogers Laurin A · Kennewick, WABuilt 1947 · S/N D-911N371RMFwd&L 525 LLC · Cataula, GABuilt 2015 · S/N 525-0900N37201U S Department Of Homeland Security · Washington, DCBuilt 1991 · S/N 550-0655N3722NSchmidt Lyle W · Los Lunas, NMS/N D-931
Back to AD 97-05-03 R1