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

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.

N233JKLcr Aviation LLC · Richland, WABuilt 2008 · S/N 560-0797 N234AQDavis Lee Enterprises LLC · Guntersville, ALBuilt 1993 · S/N 560-0234 N234LRDanish Jet Inc Trustee · Cheyenne, WYBuilt 1980 · S/N 300 N235LJMango Aviation Parts LLC · Plantation, FLS/N 297 N237CKKalitta Charters LLC · Ypsilanti, MIBuilt 1979 · S/N 237 N237VP560 LLC · Kalispell, MTBuilt 1993 · S/N 560-0237 N237WCMiro Aviation Holdings LLC · Coral Gables, FLBuilt 1980 · S/N 550-0129 N238DBLewis University · Romeoville, ILBuilt 1977 · S/N 215 N238EJFisher Elizabeth J · Odessa, TXBuilt 1997 · S/N 550-0812 N238JPJjk Acquisitions LLC · Kerman, CABuilt 2002 · S/N 550-1024 N239CDRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 339 N239VLomax John E · Powell, TNBuilt 1947 · S/N D-683 N23BKBig Sky Leasing LLC · Madison, WIBuilt 1997 · S/N 525-0198 N23FMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 296 N23YCZip-O Aviation LLC · Eugene, ORBuilt 2000 · S/N 550-0923 N23YTVision X LLC · Chattanooga, TNBuilt 2026 · S/N 525-1408 N2409KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258601 N240VN240v LLC · Wilmington, DEBuilt 1999 · S/N 258417 N241CTAvalair Aircraft Management LLC · Brookshire, TXBuilt 1981 · S/N 355 N241JSSkyland Leasing Corp · Seffner, FLS/N 258652 N242BSDm Aviation LLC · Lexington, SCBuilt 1997 · S/N 525-0230 N242LMHeritage Logistics LLC · Holdrege, NEBuilt 2017 · S/N 525-0970 N242PGPage Aviation LLC · Saint Louis, MOBuilt 2018 · S/N 525-0993 N242RFOwsley Robert L · Anchorage, AKBuilt 1998 · S/N 525-0294 N242SDBinette Alan · Medford, ORBuilt 2020 · S/N 525-1069 N243JRDodson International Parts Inc · Rantoul, KSS/N 565 N243SFMn Design Inc · Paradise Valley, AZBuilt 2002 · S/N 560-0593 N244AFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 145 N244LJN244lj Aviation Inc · Middletown, DEBuilt 1979 · S/N 244 N244RG369ba LLC · West Columbia, SCBuilt 1977 · S/N 154 N246ESFlight Services Inc · St Thomas, VIBuilt 2023 · S/N 525-1161 N246GLBonanza Management LLC · Newark, DEBuilt 2001 · S/N 525-0446 N247AJCarpe Diem 247 LLC · Evansville, INBuilt 2002 · S/N 550-1006 N247CSTeam Aero LLC · Shawnee, KSBuilt 1994 · S/N 465-27 N247DGN247dg LLC · Lawton, OKBuilt 1990 · S/N 560-0082 N247FJConquest II LLC · Kenner, LABuilt 2008 · S/N 560-0782 N247JMAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0272 N248ECEc Aviation LLC · Lake Oswego, ORBuilt 1998 · S/N 258368 N249CALafayette Flight Service LLC · Broussard, LABuilt 1998 · S/N 525-0291 N24DPEncore Cb4 LLC · Aventura, FLBuilt 2006 · S/N 560-0703 N24EWarrior Aviation LLC · Brookwood, ALBuilt 1990 · S/N 550-0651 N24GFT & T Aircraft Holdings LLC · North Salt Lake, UTBuilt 2003 · S/N 560-0639 N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037 N24QATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 560-0762 N24SMExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2002 · S/N 258567 N24XPOlive Organization LLC · El Paso, TXBuilt 2019 · S/N 525-1023 N250ADWings Air LLC · Jackson, TNBuilt 2002 · S/N 560-0605 N250PKVandelay America LLC · Newport Beach, CABuilt 2001 · S/N 560-0568 N251GMJrjgc Investments LLC · Saltillo, MSBuilt 2015 · S/N 525-0895 N252JKLow Country 525 LLC · Charleston, SCBuilt 1996 · S/N 525-0166

Back to AD 97-05-03 R1