Skip to content

Registered aircraft · 85,612

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482 N295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844178 N295GTMedina-Solla Edwin O · Carolina, PRBuilt 1966 · S/N 18257799 N295MAStanton David M Jr · Kiawah Island, SCBuilt 1995 · S/N 2811040 N295MRCarrera Air LLC · Tampa, FLBuilt 2005 · S/N 3257405 N295RNew Orleans Aviation LLC · Slidell, LABuilt 1981 · S/N 34-8133185 N295RJRegistered aircraftBuilt 1983 · S/N EA-381 N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091 N295SRCarpenter William R · West Springfield, VABuilt 1994 · S/N 3213089 N29604Farrington John R · Cedar Park, TXBuilt 1979 · S/N 28-7911182 N2960AGallman Alexander C · Livingston, TXBuilt 1953 · S/N 30160 N2960DRed Baron Rentals LLC · Jacksonville, FLBuilt 1979 · S/N 28-7916590 N2960FNaber Tania B · Niceville, FLBuilt 1953 · S/N D-3601 N2960LLucas Danny O · Ridgeland, SCBuilt 1979 · S/N 28R-7918236 N2960RVarun 2016 LLC · Florence, SCBuilt 1979 · S/N 28-7911275 N2960UMedford Mark A · Mantua, OHBuilt 1963 · S/N 17250560 N2960YHudson Maury B · Humble, TXBuilt 1979 · S/N 32-7940230 N29610Ammar Elias G · Colton, CABuilt 1979 · S/N 28-7911183 N2961AMerrill Richard C · Chuckey, TNBuilt 1953 · S/N 30161 N2961BHyldburg Aviation · Plymouth, MABuilt 1979 · S/N 28-7916591 N2961DWilliwaw Ventures LLC · Anchorage, AKBuilt 1955 · S/N 26904 N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061 N2961WKrauss Solutions LLC · Debary, FLBuilt 1979 · S/N 28-7916594 N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961 N29623Swann Hardy · Nacogdoches, TXBuilt 1979 · S/N 32R-7987123 N2962AKapsner Mark W · Willow, AKBuilt 1953 · S/N 30162 N2962BBridges Janiece · Forsyth, MOS/N D-3603 N2962DBlanchard Stephanie T · Seldovia, AKS/N 26905 N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388 N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062 N2962LAllen Marcus I · Little Elm, TXBuilt 1967 · S/N 670096 N2962RHurn Enterpises LLC · Grand Beach, MIS/N 28R-35347 N2962UFlake Philip · Pearland, TXS/N 28-7916598 N2962WB&R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 28R-7918239 N2962YGutierrez Juan · Sarasota, FLS/N 28R-7918240 N29631Registered aircraftBuilt 1973 · S/N 21059873 N29638Seal Seismic Service LLC · Oklahoma City, OKS/N 28R-7918155 N2963CMcmillian Tommy D · Wasilla, AKBuilt 1954 · S/N 30863 N2963FConnell Gary A · Anchorage, AKS/N 18257063 N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963 N2964CBrown A Russell · Lafayette, TNBuilt 1979 · S/N 28-7911279 N2964DKluge Kris D · Mound, MNBuilt 1979 · S/N 28-7911280 N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064 N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964 N2965APa 32 LLC · Union Center, WIBuilt 1979 · S/N 32-7940236 N2965CBauer Joachim · Rhome, TXFirst renewal noticeBuilt 1954 · S/N 30865 N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065 N2965RSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 34-7970425 N2965UPatterson John R · Leeds, ALBuilt 1963 · S/N 17250565 N2965WFly On LLC · Boise, IDBuilt 1979 · S/N 28-8090003

Back to AD 98-21-21 R1