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.

N804TBN804tb III LLC · Stuart, FLBuilt 1999 · S/N 258438 N805DWCwy Investments LLC · Lawrenceville, GABuilt 1981 · S/N 49 N806GJPb Air LLC · Higley, AZBuilt 2002 · S/N 258602 N806MNJm Soar LLC · Paradise Valley, AZBuilt 2003 · S/N 258605 N806SQBeco Aviation LLC · Nevada, TXBuilt 1996 · S/N 650-7060 N808MCLrt Aero Partners LLC · Sheridan, WYBuilt 2003 · S/N 258614 N80BCVaughan Aviation LLC · Leesburg, VABuilt 1986 · S/N 166 N80FMTrns Solutions LLC · Lewes, DEBuilt 1984 · S/N 650-0057 N80PGPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 063 N812LLH800 Vi LLC · Stuart, FLBuilt 2003 · S/N 258620 N812PMEl Jefe Express II LLC · Lake Forest, ILS/N 127 N812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 258683 N816JMFoxfire Aviation LLC · Henderson, NVS/N NA0207 N816KYBcp Fa Ap LLC · Providence, RIBuilt 2004 · S/N 258680 N816LCMarklyn Jet Parts LLC · Dallas, TXBuilt 1980 · S/N 291 N816LJAlliance Aviation Group LLC · Wilmington, DEBuilt 1998 · S/N 011 N817EMCentennial Capital LLC · Centennial, COBuilt 1982 · S/N 486 N817SDSea Aviation Holdings LLC · Wilmington, DEBuilt 2005 · S/N 258709 N818DEMt Gilead Full Gospel International Ministries Inc · North Chesterfield, VABuilt 1987 · S/N 650-0121 N818LXN818lx LLC · Wilmington, DEBuilt 2001 · S/N 258534 N818WBNext Wave Aviation LLC · Henderson, NVBuilt 1997 · S/N 091 N81GJGlobal Jetcare Inc · Brooksville, FLBuilt 1981 · S/N 047 N81RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 472 N81VNChromed In Hollywood Inc · Franklin, TNBuilt 1989 · S/N 652 N820CKKalitta Charters LLC · Ypsilanti, MIBuilt 1967 · S/N 120 N822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 258643 N823AMAirmed International LLC · Birmingham, ALBuilt 2004 · S/N 258687 N823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 2037 N824CCLg & Gs Holdings II LLC · Middletown, DEBuilt 1982 · S/N 55-024 N824CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 124 N824MGAti Jet Inc · El Paso, TXBuilt 1984 · S/N 106 N825JWT & C Aviation LLC · Temecula, CAS/N 217 N825LJRoyal Air Freight Inc · Waterford, MIBuilt 1983 · S/N 496 N825QTKjm Air LLC · Aurora, ILBuilt 2000 · S/N 258497 N825UWConcept Jet Services Inc · Gainesville, FLBuilt 1985 · S/N 650-0082 N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025 N826CALear Management LLC · Tulsa, OKBuilt 2002 · S/N 222 N826GCMqe LLC · Missoula, MTBuilt 1994 · S/N 258263 N828MLWalkabout Air Inc · Tampa, FLBuilt 1997 · S/N 25 N82RSFly Mda Aviation LLC · Opa Locka, FLBuilt 1997 · S/N 258336 N830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CABuilt 1991 · S/N 222 N831LXM&N Equipment LLC · Englewood, COBuilt 2000 · S/N 258510 N831PC505sj LLC · Jackson, TNBuilt 2001 · S/N 140 N831RWHigher Purpose LLC · Ellisville, MOBuilt 1985 · S/N 160 N831VPAlana 650 Aircraft LLC · Waterford, MIBuilt 1990 · S/N 650-0194 N834AFFenair LLC · Toledo, OHBuilt 2001 · S/N 225 N835MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 673 N83FJCj Aviation LLC · Kalispell, MTBuilt 1981 · S/N 74 N83FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 007 N840BMJsj LLC · Wilmington, DEBuilt 2000 · S/N 650-7118

Back to AD 98-17-01 R1