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.

N923JHHarper Excavating Inc · Salt Lake City, UTBuilt 1992 · S/N 550-0708 N923TBCaffey Distributing Company Inc · Greensboro, NCBuilt 2024 · S/N 525-1166 N924CBJet Air Inc · Iowa City, IABuilt 1997 · S/N 550-0820 N924XSchieffer Enterprises LLC · Kurten, TXBuilt 2015 · S/N 525-0865 N925CACasmos LLC · Wilmington, DES/N 605 N925JATrue North Aviation LLC · Harrisburg, SDBuilt 2017 · S/N 525-0963 N925MPApegasus LLC · Shelbyville, INBuilt 2000 · S/N 258457 N926CESilverado Aviation LLC · Fort Wayne, INBuilt 2007 · S/N 560-0763 N926NCBb & Ryder LLC · Greenbrier, ARBuilt 1995 · S/N 560-0328 N927PKSymmetry Aviation LLC · Mount Pleasant, TXBuilt 2001 · S/N 560-0551 N928HRHoward Aviation LLC · San Antonio, TXBuilt 1984 · S/N 415 N929JTDulcich Nick Prosper · Bakersfield, CABuilt 1993 · S/N 525-0011 N929MMOtm Equipment LLC · Westlake, TXBuilt 2009 · S/N 525-0692 N92CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 092 N92SBLone Star Air LLC · Castle Rock, COBuilt 2022 · S/N 525-1106 N92SSUS Trinity Equipment LLC · Argyle, TXBuilt 1996 · S/N 560-0388 N92UPTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1997 · S/N 258309 N92WGDndd Capital Holdings LLC · Plano, TXBuilt 2015 · S/N 525-0871 N931CAWild Aviation LLC · Rockford, ILBuilt 2002 · S/N 258586 N931ELSworks Aviation LLC · Chicago, ILFirst renewal noticeBuilt 1996 · S/N 258316 N931SRIsr Aviation LLC · Wilmington, DES/N 525-0175 N931TNJude Aviation LLC · Clarksville, TNBuilt 2023 · S/N 525-1150 N933PBApp Concepts LLC · Wichita, KSBuilt 2002 · S/N 560-0618 N933RGMsblt LLC · Hobe Sound, FLBuilt 2016 · S/N 525-0933 N934CWM2 Aviation LLC · Rockledge, FLBuilt 2016 · S/N 525-0934 N936HRPymp LLC · Nashville, TNBuilt 2005 · S/N 258743 N936JLConcrete Structures LLC · Jupiter, FLBuilt 1980 · S/N 465-43 N938AMCase Services LLC · Scottsdale, AZBuilt 2000 · S/N 550-0938 N939DCCraine Daniel J · Fort Worth, TXBuilt 1981 · S/N 550-0329 N939TWGulf Atlantic Airways Inc · Gainesville, FLBuilt 1992 · S/N 560-0185 N93CVRosebriar Holdings Corp · Dallas, TXBuilt 1993 · S/N 560-0239 N93DBForce Pressure Control LLC · Seguin, TXBuilt 1994 · S/N 560-0280 N93FSEubel Brady & Suttman Asset Management Inc · Miamisburg, OHBuilt 1999 · S/N 560-0518 N93HATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 560-0493 N93LECorsair Two LLC · Hillsboro, ORS/N 592 N940SWBh Aero LLC · Birmingham, ALBuilt 1994 · S/N 5250071 N941JPCypress Aircraft Sales LLC · Clermont, FLBuilt 1981 · S/N 550-0313 N943TFHometowne Aviation LLC · Jackson, TNBuilt 1991 · S/N 550-0665 N944BBSun Aviation LLC · Indianapolis, INBuilt 2003 · S/N 258611 N944JAircraft N944j LLC · Metairie, LABuilt 2017 · S/N 525-0944 N944KRJcon Leasing LLC · Nashville, TNBuilt 2004 · S/N 258688 N945WRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 301 N946NANational Aeronautics And Space Administration · Houston, TXBuilt 1974 · S/N 146 N946TSTsp Leasing Company LLC · Tacoma, WABuilt 2007 · S/N 560-0765 N946WTSeth Roberts Aviation LLC · Seguin, TXBuilt 1997 · S/N 258347 N947HCHarrison Contracting Co Inc · Villa Rica, GABuilt 1994 · S/N 525-0077 N949JABemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258362 N94ALBbj Ventures LLC · Goldsboro, NCBuilt 2001 · S/N 525-0432 N94GPJr Aviation LLC · El Cajon, CABuilt 1981 · S/N 411 N950HIsland Aviation Inc · Houston, TXBuilt 2000 · S/N 307

Back to AD 97-05-03 R1