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.

N51NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 126 N520AJAction Jet Aviation LLC · Woodland Hills, CABuilt 1997 · S/N 560-0437 N520AWGg Flight LLC · Findlay, OHBuilt 1981 · S/N 453 N520BPToy Air Inc · Southfield, MIBuilt 1989 · S/N 560-0031 N520DFPar Avion LLC · Ketchum, IDBuilt 1996 · S/N 525-0154 N520NANasa Langley Research Center · Hampton, VAS/N 86-0206 N521AAOne Alpha Alpha LLC · Oakland, CABuilt 2016 · S/N 525-0920 N521JKSale Reported · Beverly Hills, CASale reported, canceledBuilt 1994 · S/N 258262 N521LFThin Air Associates LLC · Pottsville, PABuilt 1991 · S/N 5600132 N521PFAlton Blakley Aviation Inc · Somerset, KYBuilt 1993 · S/N 525-0005 N521TMN521tm LLC · Eagle, IDBuilt 1992 · S/N 550-0705 N521VPMoo Too 1 Inc · Middletown, DEBuilt 1995 · S/N 560-0312 N521ZBVivre Investments LLC · Weslaco, TXBuilt 2019 · S/N 525-1031 N522AJAj Capital Holdings LLC · The Woodlands, TXBuilt 1994 · S/N 525-0068 N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282 N522GLGreat Lakes Aviation LLC · Akron, OHBuilt 2010 · S/N 525-0697 N522KLClearview Investments LLC · Lexington, TNBuilt 2016 · S/N 525-0939 N522WPM & M Aviation LLC · Lincoln, NEBuilt 2016 · S/N 525-0924 N523YATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 560-0291 N5245NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-109 N524PAPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 033 N524TFBgmg LLC · San Antonio, TXBuilt 2022 · S/N 525-1136 N524XAOn Three Angels Wings LLC · Melbourne, FLBuilt 2001 · S/N 550-0988 N5255BWest Wind Air LLC · Lake Village, ARBuilt 1997 · S/N 525-0231 N525AQM2ntt LLC · Houston, TXBuilt 2024 · S/N 525-1164 N525AWD And D Aviation LLC · Tahoe City, CABuilt 2000 · S/N 525-0369 N525BDN300bb LLC · Melbourne Beach, FLBuilt 2026 · S/N 525-1407 N525BPPmi Aviation LLC · Fishers, INBuilt 2002 · S/N 525-0479 N525BRDk Aviation LLC · Pittsford, NYBuilt 2001 · S/N 525-0444 N525BTWhiting Wings LLC · Alexander, ARBuilt 1996 · S/N 525-0161 N525BWRegistered aircraftBuilt 2000 · S/N 525-0409 N525CJettech Holdings LLC · Broomfield, COBuilt 1999 · S/N 525-0332 N525CDLincoln Transport D LLC · Newark, DEBuilt 2000 · S/N 525-0360 N525CHRebus II LLC · Owasso, OKBuilt 1994 · S/N 525-0078 N525CMD Bar K LLC · Gatesville, TXBuilt 1995 · S/N 525-0093 N525CPAdios Aviation LLC · Austin, TXBuilt 1997 · S/N 525-0228 N525CXCentrex Construction Inc · Tigard, ORBuilt 2011 · S/N 525-0700 N525DCMalmstrom White Co · Little Rock, ARBuilt 1997 · S/N 525-0195 N525DPElk Factoring LLC DBA · Staunton, VABuilt 1999 · S/N 525-0318 N525DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 5250062 N525DUFtc Air Holdings 2 LLC · Tampa, FLBuilt 1997 · S/N 525-0205 N525EBellevue Advisors LLC · San Mateo, CABuilt 2014 · S/N 525-0853 N525FCExponential Thinking LLC · Houston, TXBuilt 2004 · S/N 525-0531 N525FNMci Air LLC · Dover, DEBuilt 2000 · S/N 525-0368 N525GCSav Aviation LLC · Jacksonville, TXBuilt 1994 · S/N 5250065 N525GEKek Companies Inc · Portland, ORFirst renewal noticeBuilt 2008 · S/N 525-0679 N525GKG Money LLC · Delavan, WIBuilt 1994 · S/N 525-0052 N525GLSk872 LLC · Wilmington, DES/N 525-0872 N525HCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1998 · S/N 525-0270 N525HLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 525-0808

Back to AD 97-05-03 R1