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.

N1830BLeading Edge Leasing LLC · Wilmington, DEBuilt 1981 · S/N TC-2410 N1831SCasson Christopher C · Klamath Falls, ORBuilt 1981 · S/N WA-302 N18354Rich Broke Entertainment LLC · Conyers, GABuilt 1977 · S/N TC-2077 N18357Williams Randall G · Edgewater, MDBuilt 1977 · S/N TC-2078 N1835BUtermoehlen Rickey D · Grass Valley, CABuilt 1977 · S/N TC-2076 N18373T Mitchell Holdings Inc · Binghamton, NYBuilt 1981 · S/N TC-2415 N18387Rizzuti Robert T · Theodosia, MOBuilt 1977 · S/N TC-2080 N1838LGordon Martin A · South Amboy, NJS/N TC-2008 N1839WTown & Country Auto Sales LLC · Winchester, KYBuilt 1973 · S/N TC-1514 N183FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63114 N183UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1539 N18446Descro Air LLC · Henderson, KYBuilt 1977 · S/N TC-2086 N18448Redd Horse LLC · Wilmington, DEBuilt 1977 · S/N TC-2087 N18472Cherry Michael · Corolla, NCBuilt 1978 · S/N TC-2155 N1848NMeserve Guy S · Sandpoint, IDBuilt 1982 · S/N WA-312 N1848WLee Clarence K · Colleyville, TXBuilt 1973 · S/N TC-1534 N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68 N184ERIxi LLC · West Bloomfield, MIBuilt 1979 · S/N ME-267 N184FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63115 N184HPGries John R · Haslet, TXBuilt 1979 · S/N TC-2248 N184SKBank Of Utah Trustee · Salt Lake City, UTS/N 28284 N184USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1651 N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184 N1850NSnohomish Flying Service Inc · Snohomish, WABuilt 1981 · S/N ME-429 N1853BAltius Aviation LLC · Syracuse, NYBuilt 1981 · S/N TC-2420 N185DNDelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27961 N185FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63116 N185KJJah 2022a Saab340b Msn 185 LLC · Dallas, TXBuilt 1990 · S/N 340B-185 N185UWAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1666 N1861LBaker James W · Goodland, KSBuilt 1976 · S/N TC-1964 N186DNDelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27962 N186FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63117 N186USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1701 N1871WCitationxtango LLC · Kennett Square, PABuilt 1973 · S/N TC-1563 N18746Pas Inc · Townsend, DES/N TC-2094 N1879ERaw Racing Inc · Puyallup, WAS/N 340A0658 N187DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 27582 N187FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63118 N187USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1704 N188Gear Robert Lee III · Paradise Valley, AZFirst renewal noticeS/N LC70 N1881LSwept Wing Aviation LLC · Murfreesboro, TNBuilt 1976 · S/N TC-1968 N188DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 27583 N188FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63119 N188JMKc Aviation Partners LLC · Wilmington, DES/N 32629 N188NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5669 N188SAAlliance Aviation Group LLC · Wilmington, DEBuilt 1990 · S/N 1150 N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636 N188USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1724 N188YMbaa Holding LLC · Myrtle Beach, SCBuilt 1964 · S/N TC-790 N18929Vector Aviation LLC · Mentor, OHBuilt 1978 · S/N ME-6

Back to AD 95-26-15 R1