Registered aircraft · 1,201

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:98-17-01-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:98-17-01-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:98-17-01-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:98-17-01-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:98-17-01-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:98-17-01-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.

N303PM303pm LLC · Lakewood, COBuilt 1982 · S/N 103 N303XX303 Aviation LLC · North Plains, ORS/N 196 N304PCFlorida Avm LLC · Venice, FLBuilt 1986 · S/N 650-0110 N305BBBsc Landing LLC · Saint Louis, MOBuilt 1999 · S/N 105 N306PAAerotrust Services Corp Trustee · Wilmington, DES/N 650-0053 N307DLNova Jets USA Corp · Orlando, FLS/N 2002 N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307 N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665 N308MRStonegate Holdings LLC · San Antonio, TXBuilt 1988 · S/N 650-0153 N30AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 141 N30LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 1988 · S/N 002 N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225 N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152 N30TKGravitas Aero LLC · Dallas, TXBuilt 1982 · S/N 374 N310LJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 031 N310ZAZair Force One LLC · Mendenhall, MSBuilt 1987 · S/N 009 N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314 N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338 N311KBJet Plaid LLC · Nashville, TNBuilt 2004 · S/N 135 N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222 N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545 N312LGJet Masters LLC · Englewood, COBuilt 1982 · S/N 489 N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436 N312WMWoodhill Aviation Corp · Elk Grove Village, ILBuilt 1991 · S/N 224 N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133 N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400 N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480 N315SCInternational Skychase Corp · Alachua, FLBuilt 1982 · S/N 130 N316CLCalco 316 LLC · Frisco, TXBuilt 1993 · S/N 6507032 N316TDBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 312 N3170BSpring Mountain Enterprises Inc · Corvallis, ORS/N 650-0136 N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532 N317TTInter Island Yachts Inc · Zephyr Cove, NVBuilt 1980 · S/N 317 N318NWMed Jets USA Inc · Boca Raton, FLBuilt 1980 · S/N 318 N31DTFa31dt LLC · Owasso, OKBuilt 1997 · S/N 147 N31GJGlobal Jetcare Inc · Brooksville, FLBuilt 1976 · S/N 022 N31KHAery Aviation LLC · Wilmington, DEBuilt 1999 · S/N 173 N31LJDelta November LLC · Lewes, DEBuilt 1994 · S/N 097 N31RARoyal Air Freight Inc · Waterford, MIBuilt 1979 · S/N 288 N31YAInternational Trading Energy Fuels LLC · Houston, TXBuilt 1990 · S/N 021 N31ZVEzair International Leasing And Management Inc · Wilmington, DEBuilt 1996 · S/N 127 N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437 N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523 N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366 N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515 N321VAValiair Limited Co Trustee · Casper, WYBuilt 1997 · S/N 650-7077 N322GC1mg LLC · Fort Wayne, INBuilt 1990 · S/N 142 N322PRN322pr LLC · Scottsdale, AZBuilt 1991 · S/N 038 N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155 N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325

Back to AD 98-17-01 R1