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.

N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101 N6013FMile Fly Club LLC · Gainesville, TXBuilt 1965 · S/N TC-888 N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112 N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147 N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141 N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145 N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156 N60199Krystofiak Steven · Scottsdale, AZBuilt 1979 · S/N WA-12 N601AWAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 1935 N601NKBank Of Utah Trustee · Sale Lake City, UTBuilt 2010 · S/N 4206 N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71 N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130 N6024QAero Equities LLC · Ventura, CABuilt 1979 · S/N TC-2209 N6024U6024u Aircraft Leasing LLC · Spanish Fork, UTBuilt 1979 · S/N TC-2210 N60295Neufield Jim R DBA · Wasco, CABuilt 1979 · S/N TC-2217 N602DKGingerjet LLC · Boca Raton, FLBuilt 1967 · S/N TE-369 N602FCStarr Travis W · Helotes, TXS/N TC1624 N602KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23306 N602NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4264 N6030WAllen James Robert · Glasgow, KYBuilt 1979 · S/N TC-2219 N6033XBennett Jerry W Jr · Spring Branch, TXBuilt 1979 · S/N TC-2220 N60343Crow William David · Katy, TXS/N TC-2222 N6037WMidland Community College District · Midland, TXBuilt 1979 · S/N TC-2238 N603AWNational Test Pilot School · Mojave, CABuilt 1981 · S/N 46572 N603AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48267 N603JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2352 N603KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23213 N603NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4321 N60405Aero Quest LLC · Olive Branch, MSBuilt 1979 · S/N ME-173 N6041UCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N ME-175 N6042FFly Aviation Corp · Wilmington, DEBuilt 1979 · S/N ME-176 N6043YFreeman Eugene P · Paducah, KYBuilt 1979 · S/N WA-16 N60451Jkg LLC · Murfreesboro, TNBuilt 1979 · S/N ME-193 N6049LExecutive Flight Institute LLC · Murrieta, CABuilt 1979 · S/N ME-202 N604AABischoff Aerospace Inc · Doral, FLBuilt 1995 · S/N 27055 N604AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1196 N604JMRegistered aircraftS/N 1301 N604KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1988 · S/N 24145 N604NKBank Of Utah Trustee · Salt Lake City, UTS/N 4431 N60520Kemp Charles Wilson · Richmond, VABuilt 1979 · S/N TC-2227 N6057DValentine Jimmie L Trustee · Frisco, TXBuilt 1979 · S/N TC-2233 N605JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2368 N605KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1984 · S/N 23180 N605NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4548 N605RASmb G-IV Vii LLC · Longwood, FLBuilt 1987 · S/N 1028 N606AAStrategic Odyssey I LLC · Miami, FLFirst renewal noticeBuilt 1996 · S/N 27057 N606JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2384 N606KWAlta 767 Spv LLC · Salt Lake City, UTS/N 24324 N606MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1107 N606NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4592

Back to AD 95-26-15 R1