Registered aircraft · 1,185

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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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.

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

Back to AD 82-23-03 R1