OpenAirDocs.org
AD 98-17-01 R1

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
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.

N40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 2041N40GPBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 45-2061N411SCRegistered aircraftBuilt 2004 · S/N 258653N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061N412SWThunderforce Investments LLC · Washington, DCBuilt 2002 · S/N 238N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413N413MHFastair Inc · Columbia Station, OHBuilt 1987 · S/N 650-0148N414PEAerotrust Services Corp Trustee · Wilmington, DES/N 258090N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657N418DLRsb Investments LLC · Washington, PABuilt 1999 · S/N 181N419MKAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1993 · S/N 066N41GJGlobal Jetcare Inc · Brooksville, FLBuilt 1984 · S/N 055N421SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 660N422CSBusiness Jet Managers Inc · Canton, MIBuilt 1988 · S/N 258110N423SGSworks Aviation LLC · Chicago, ILS/N 258472N424JRGravitas Aviation LLC · Dallas, TXBuilt 1984 · S/N 405N424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 169N427RRTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 6500178N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154N429FCLopez Fabio · Denver, NCBuilt 1983 · S/N 091N42GEWatts John · Murchison, TXBuilt 1974 · S/N 20N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509N431CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 431N431DARegistration Pending · Lewes, DERegistration pendingBuilt 1998 · S/N 163N432SMWorldwide Option LLC · Lewes, DEBuilt 1996 · S/N 258293N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641N437SJBank Of Utah Trustee · Salt Lake City, UTBuilt 1986 · S/N 437N43MFMed Flight Air Ambulance Inc · Albuquerque, NMBuilt 1980 · S/N 284N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628N440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 85N440RDDodson International Parts Inc · Rantoul, KSS/N 25270N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524N441PCAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1992 · S/N 668N442MSWd Aviation Group Inc · Atlanta, GAS/N NA0460N444CWTexas Aero Jet Sales 1 LLC · Wilmington, DEBuilt 1984 · S/N 650-0064N444HCPdii LLC · Concord, NCBuilt 1992 · S/N 064N444PERaptor Aviation Inc · Port Saint Lucie, FLBuilt 1984 · S/N 143N445NAirblue Eagle Inc · Houston, TXBuilt 2002 · S/N 202N448GRVenti Air Service Inc · Coral Gables, FLBuilt 1993 · S/N 070N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573N44MQAircraft Holdings Solutions LLC Trustee · Newark, DEBuilt 1994 · S/N 6507043N44RFKtpt Capital Holdings LLC · Hilton Head Island, SCBuilt 1985 · S/N 650-0072N44VPGable S Corp · West Linn, ORBuilt 2002 · S/N 115N450KVTop Gun Air LLC · Pompano Beach, FLBuilt 2000 · S/N 098N450TJJaco Oil Co · Bakersfield, CABuilt 1998 · S/N 012N451CKKalitta Charters LLC · Ypsilanti, MIBuilt 1999 · S/N 063N451CLCollins Aviation LLC · Sioux City, IABuilt 1991 · S/N 223N451SJTexas Mna LLC · Westlake, TXBuilt 2001 · S/N 173N452CFHangar LLC · Las Vegas, NVBuilt 1982 · S/N 104N452CJScg Leasing LLC · Owensboro, KYBuilt 2000 · S/N 090
Back to AD 98-17-01 R1