Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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.

N874CTrans-Exec Air Service Inc · Van Nuys, CABuilt 1993 · S/N 1219 N874TWUnited States Government · Washington, DCBuilt 1989 · S/N 24524 N87536Krull Jesse L · Bismarck, NDBuilt 1981 · S/N 340A1254 N8769RPochwatka Patryk · Treasure Island, FLBuilt 1974 · S/N TC-1790 N876GLGlj Aviation LLC · Pompano Beach, FLBuilt 2001 · S/N 1454 N8772RLevity Holdings LLC · Little Rock, ARBuilt 1974 · S/N TC-1795 N877AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2001 · S/N 1461 N877FBOverlander Aviation LLC · Palo Alto, CABuilt 1962 · S/N TC-298 N877LCLetica Leasing LLC · Rochester Hills, MIBuilt 1991 · S/N 1165 N877SPElizabeth City State University · Elizabeth City, NCS/N ME-310 N878SMWorld Heir Inc · College Park, GABuilt 1997 · S/N 1319 N8792KTornado Venture Once LLC · San Antonio, TXBuilt 1980 · S/N 340A0985 N8795RPrice Ronald M Trustee · Bonita Springs, FLBuilt 1974 · S/N TC-1798 N8796RSea2sky Aviation LLC · Dover, DEBuilt 1974 · S/N TC-1807 N8797RAirflyte LLC · Granby, CTBuilt 1974 · S/N TC-1812 N87DPGo Pilot LLC · Orlando, FLBuilt 1964 · S/N TC-696 N87EDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-05 N87QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-60 N87VDynamic Avlease Inc · Bridgewater, VAS/N LM-130 N8801GAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 340A0986 N880CFBoss 8 LLC · Fort Worth, TXBuilt 1988 · S/N 1082 N880TSSolano J Thomas · Ponte Vedra Beach, FLBuilt 1974 · S/N TC-1722 N880TWEnvisage LLC · Virginia Beach, VABuilt 1969 · S/N TC-1240 N8814Eer LLC · Camp Hill, PAS/N TC-1337 N881CDWestern Pilot Service Inc · Phoenix, AZBuilt 1958 · S/N TD-95 N883LDV-Jet Aircraft Holding Co Trustee · Dover, DEBuilt 2001 · S/N 1441 N8845MFodor Vincent A · Doylestown, OHBuilt 1964 · S/N TC-596 N884CFN360kv LLC · Modesto, CABuilt 2001 · S/N 1435 N884EATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 387 N88521Godfrey Pharis · Missouri City, TXBuilt 1981 · S/N 340A1260 N88549Seed Richard J IV · Holmes Beach, FLBuilt 1981 · S/N 340A1261 N88555Iverson Douglas B · Sammamish, WABuilt 1981 · S/N 340A1262 N8856KHerrmann Alan J · Laguna Niguel, CABuilt 1981 · S/N 340A1264 N8857KBall Bearing Aviation LLC · Lowell, ARBuilt 1979 · S/N 340A0642 N886BATerzo Richard E · Lake Zurich, ILBuilt 1981 · S/N 340A1269 N887MRFouga LLC · Dover, DEBuilt 1994 · S/N 1251 N888BPXyz1234 LLC · Addison, TXBuilt 1979 · S/N 340A0737 N888CSZg Aviation LLC · New York, NYBuilt 2001 · S/N 1469 N888ESSpinair LLC · Saratoga, CABuilt 1989 · S/N 1120 N888FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1041 N888JTNyerges James · Midland, TXFirst renewal noticeBuilt 1966 · S/N LP-21 N888LTAero Micronesia Inc DBA · Barrigada, GUBuilt 1992 · S/N 25441 N888MFSn 1268 Inc · Wilmington, DEBuilt 1995 · S/N 1268 N888MTSpelts Mark Warren Trustee · Chico, CABuilt 1979 · S/N 340A0763 N888NNorman James R · San Diego, CABuilt 1973 · S/N 340-0312 N888UPTeam Aero LLC · Shawnee, KSBuilt 1981 · S/N 465-68 N888YGGy Gulfstream LLC · Las Vegas, NVBuilt 2003 · S/N 1519 N889BHPrima Air Group LLC · Pasadena, CABuilt 1989 · S/N 1121 N889CGPrima Air LLC · Pasadena, CABuilt 1999 · S/N 1386 N88JTKimberlin Mark · Indio, CABuilt 1974 · S/N TC-1753

Back to AD 95-26-15 R1