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.

N13CRPreferred Aviation LLC · Fayetteville, ARS/N 560-0056 N141SLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 306-141 N142RNNelson Robert J · Carbondale, ILBuilt 1948 · S/N D-1353 N144KMKcc Av LLC · Fayetteville, ARBuilt 2001 · S/N 560-0579 N144ZVN129rp LLC · Tulsa, OKBuilt 2000 · S/N 550-0926 N145KKDodson International Parts Inc · Rantoul, KSBuilt 1994 · S/N 560-0276 N146MMJackdaw Inc Trustee · Wilmington, DEBuilt 1997 · S/N 5250226 N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214 N1482BClear Line Aviation LLC · St George, UTBuilt 2015 · S/N 525-0888 N149HC149hc LLC · Bend, ORBuilt 1999 · S/N 550-0898 N14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 258317 N150EXDodson International Parts Inc · Rantoul, KSS/N 262 N150GPSteel Aircraft Leasing LLC · Saint Augustine, FLS/N 560-0127 N150JMPog Capital LLC · Wilmington, DEBuilt 1998 · S/N 258382 N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324 N150SSSweetener Supply Corp · Brookfield, ILBuilt 1987 · S/N 213 N152JHSeaport Aviation Inc · Quincy, MABuilt 2002 · S/N 560-0615 N152KVPlane House LLC · Indianapolis, INBuilt 1996 · S/N 525-0152 N153TN153t LLC · Kalispell, MTS/N 550-0732 N154JKRacd Holding LLC · Pembroke Pines, FLBuilt 1991 · S/N 560-0128 N154RRN154rr LLC · Wilmington, DEBuilt 1998 · S/N 258375 N155BWPoet Inc · Sioux Falls, SDBuilt 2018 · S/N 525-0988 N155CGBigees Air LLC · Sioux Falls, SDBuilt 1997 · S/N 525-0214 N155PTWaypoint Aviation LLC · Wilmington, DEBuilt 1994 · S/N 560-0257 N1569ZTran Danh · Moreno Valley, CAS/N D-1107 N156GWM-W Air Lc · Horseshoe Bay, TXBuilt 2001 · S/N 550-0982 N156MLAir Miles LLC · River Falls, WIBuilt 1996 · S/N 525-0156 N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668 N157MDDunbar Kevin R · Belmont, NCBuilt 1947 · S/N D-1150 N157TFMeyers Aircraft Trading West LLC · Windermere, FLBuilt 1991 · S/N 560-0157 N158JSMae Aviation LLC · Dover, DEBuilt 2000 · S/N 560-0540 N1599VQuigley Ryan P · Chemung, NYBuilt 1947 · S/N D-55 N159FMC&K Air LLC · New Castle, DEBuilt 2003 · S/N 258651 N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024 N15EDClearview Aviation Group LLC · Peachtree City, GABuilt 2015 · S/N 525-0855 N15JTSignalwave LLC · Ocala, FLBuilt 1989 · S/N 560-0015 N15RKPlane Part Solutions LLC · Lake Park, FLBuilt 1996 · S/N 258297 N15RNExecutive Jet A LLC · Danbury, CTBuilt 1999 · S/N 560-0520 N15SLCp Ultra LLC · Sacramento, CABuilt 1994 · S/N 560-0272 N15WEFirstrike Aviation LLC · Tulsa, OKBuilt 2014 · S/N 525-0847 N15WTJet Amigos LLC · Central Point, ORBuilt 1982 · S/N 550-0423 N161TMHudson Air LLC · Hudson, OHBuilt 1999 · S/N 550-0867 N162TJMcm Jet LLC · Mooresville, NCBuilt 1999 · S/N 550-0888 N163CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 163 N163PAN163pa LLC · Wilmington, DEBuilt 1982 · S/N 249 N164RAJetway N164 LLC · Brooklyn, OHBuilt 2007 · S/N 560-0766 N166STGable S Corp · West Linn, ORBuilt 2002 · S/N 560-0606 N167SCSage Creek Aviation LLC · American Canyon, CABuilt 2005 · S/N 258742 N168BGValle Aviation Inc · Nashville, GABuilt 1995 · S/N 5600301 N168ESNext Generation Aviation LLC · Beloit, WIBuilt 1992 · S/N 550-0706

Back to AD 97-05-03 R1