Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N80094Hartshorn Michael P · Danville, ILBuilt 1976 · S/N 17266366 N80095Ivy James E · Alba, TXBuilt 1975 · S/N 17266367 N80097Yates Gregory A · Murrayville, ILBuilt 1975 · S/N 17266368 N8009AMiles Austin B · Bend, ORBuilt 1952 · S/N 20861 N8009BTaber Floyd K · Osceola, IABuilt 1957 · S/N 29809 N8009FRucinski Edward A · Climax, NCBuilt 1966 · S/N 15064109 N800DFFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700621 N800FMartin Tyler · Waco, TXBuilt 1964 · S/N 205-0520 N800FCFargo Curt J · Vacaville, CAS/N 17256726 N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792 N800HEFredericks Kenneth L · Halliday, NDBuilt 1965 · S/N 15061602 N800HPSanders George W Jr · Cloverdale, INFirst renewal noticeBuilt 1979 · S/N 18266903 N800JKWingjet Aviation LLC · Howard City, MIBuilt 1975 · S/N 18263593 N800JWImperial Valley Flight Training LLC · Calexico, CABuilt 1973 · S/N 18262541 N800LC54 Aero LLC · Spade, TXBuilt 1968 · S/N 18258879 N800LGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000669 N800MDPark Whitney Foutz · Boulder, COBuilt 1977 · S/N 17269123 N800MLNaples LLC · Mound City, MOBuilt 1966 · S/N 18257132 N800NLNewhalen Lodge Inc · Anchorage, AKBuilt 1979 · S/N U20604860 N800PReisch Travis S · Miami, OKBuilt 1983 · S/N 18268305 N800TGAftg Aviation LLC · Hopkins, MIBuilt 1978 · S/N R18200683 N800TYAvcorp Holdings Inc · Jackson, MIBuilt 1978 · S/N 15282202 N800WBBestgen Walter E II · Deltona, FLBuilt 1981 · S/N 18504262 N800WEOptic Air LLC · Maurice, IABuilt 1979 · S/N 18267408 N80102Transonic LLC · Wilmington, DES/N 17266369 N80105Heilmann Charles E · Millwood, WVBuilt 1975 · S/N 17266371 N80106American Patrols Inc · Midland, TXBuilt 1975 · S/N 17266372 N8010ATaylor Michael A · Pipestone, MNBuilt 1952 · S/N 20862 N8010FTorres Mora Jose Alberto · Modesto, CABuilt 1966 · S/N 15064110 N8010LLegion Flying Club Inc · Springfield, MABuilt 1967 · S/N 17256210 N8010ZRosander Mining Co Inc · Mc Grath, AKBuilt 1965 · S/N U206-0410 N80112Lind Enterprises LLC · Manistee, MIBuilt 1975 · S/N 17266377 N80116Laingkids LLC · Lewes, DEBuilt 1975 · S/N 17266380 N80117Valley Fliers Flying Club · Auburn, WABuilt 1975 · S/N 17266381 N80118Skylens LLC · Hammond, LABuilt 1975 · S/N 17266382 N80119Wellman David H · Eugene, ORBuilt 1975 · S/N 17266383 N8011GLadner Marvin D · Sidney, NYBuilt 1970 · S/N 177RG0011 N8011LLaska Lonny J · Tonawanda, NYBuilt 1967 · S/N 17256211 N8011TDykstra Wayne A · Pipestone, MNBuilt 1960 · S/N 56711 N8011ZJackson Jet Center · Boise, IDS/N U206-0411 N80121Sky Gypsies LLC · Lansdale, PABuilt 1975 · S/N 17266384 N80123Fremont Aviation Inc · Fremont, NEBuilt 1975 · S/N 17266385 N80124Amundsen John D · Soldotna, AKS/N 18503094 N80127J C Dalco Inc · Westminster, CABuilt 1975 · S/N 17266388 N80128Gonzalez William I · Babylon, NYBuilt 1975 · S/N 17266389 N80129Potter Raymond C · Torrey, UTBuilt 1975 · S/N 17266390 N8012FHood William T · Columbia, SCBuilt 1966 · S/N 15064112 N8012SCollins Scott · Upland, CABuilt 1965 · S/N 15061612 N8012XSingh Joga · Auburn, WABuilt 1961 · S/N 17248512 N80130Harrison W Henry · Philadelphia, PABuilt 1975 · S/N 17266391

Back to AD 87-20-03 R2