Skip to content

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.

N661DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24972 N661FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 760 N661JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3228 N661KQDaybreak Aviation LLC · Wellington, ALS/N TC-2293 N661NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6867 N661QS&S Aircraft Inc · Bennington, VTBuilt 1959 · S/N TD-214 N661UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27158 N661USDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 23719 N6625DFox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-203 N66265Russo James F · Hilton Head Island, SCBuilt 1979 · S/N ME-207 N66272Fox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-216 N6627XIsiah 4031 LLC · Quakertown, PABuilt 1979 · S/N ME-215 N6628XAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-218 N6628YAri Ben Aviator Inc · Ft Pierce, FLBuilt 1979 · S/N ME-219 N662AWUS Bank National Association Trustee · Boston, MABuilt 2000 · S/N 1274 N662DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 24991 N662FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 761 N662JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3263 N662NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6897 N662TSchoch Michael Pa · Punta Gorda, FLBuilt 1958 · S/N TD-70 N662UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27159 N66301Guidry David Brian · Lake Charles, LAFirst renewal noticeBuilt 1979 · S/N WA-29 N6630TRoberts Joshua E · Pike Road, ALBuilt 1980 · S/N WA-107 N6632JSo Cal Leasing LLC · El Cajon, CABuilt 1980 · S/N ME-337 N6632UFox Falley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-323 N66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-239 N66340Wickline Wayne · Flower Mound, TXBuilt 1979 · S/N ME-241 N6634BAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N ME-234 N66352Seaplane Adventures LLC · Cheyenne, WYBuilt 1979 · S/N ME-251 N6635BChandler Jerome P · Redondo Beach, CABuilt 1979 · S/N ME-245 N6636LAoa Kissimmee Inc · Kissimmee, FLBuilt 1979 · S/N ME-256 N6636TVincent Air LLC · Carroll, IABuilt 1979 · S/N ME-259 N6637RSchawang Darrin E · Falls City, NES/N WA-35 N6638HWright Aero Inc · Saint Cloud, MNBuilt 1979 · S/N ME-266 N6638LNewby Danny A · Mc Leansville, NCBuilt 1979 · S/N WA-37 N663AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1419 N663DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 24992 N663FEFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 766 N663GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27568 N663JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3287 N663NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 6994 N663UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27160 N6645YDietl Manfred · Naples, FLBuilt 1979 · S/N TC-2258 N6648WN6648w LLC · Wilmington, DES/N TC-2242 N664AVAvsa Leasing 3 · Wilmington, DEBuilt 2008 · S/N 3664 N664AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1621 N664DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25012 N664FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 768 N664GBTcc Air Services Inc · Greenwich, CTS/N TC-2093 N664NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7021

Back to AD 95-26-15 R1