OpenAirDocs.org
AD 2020-21-22

Registered aircraft · 6,392

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

N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677N1009PFerrier William T · Woodland, CABuilt 1958 · S/N 34994N100MMFarmer Aviation LLC · Milan, MIS/N 33611N100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684N101APatterson Mark T · Kodiak, AKBuilt 1959 · S/N 50486N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691N1027XHarper Shawn · Bayfield, COBuilt 1954 · S/N 31205N1028FLunoe Leif C · Anchorage, AKBuilt 1975 · S/N 18502695N102CDrain Alan K · Columbus, MTS/N 30501N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700N1044SHubbell Wallis E · Tucson, AZS/N 52829N1047FBondurant Jok · Talkeetna, AKS/N 18502704N104BWJurak Mike D · Kimberly, IDBuilt 1974 · S/N 18502517N104DEVince John G · West Ossipee, NHBuilt 1980 · S/N 18504009N104HEDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1975 · S/N 18502742N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693N104RCChan Ronald G · Anchorage, AKBuilt 1966 · S/N 1851098N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709N1056FBrasil John I · Lemon Grove, CABuilt 1975 · S/N 18502712N105NBNorthcentral Aircraft LLC · Blaine, MNBuilt 1984 · S/N 18503732N1060FStrausbaugh Paul L · Clifton Forge, VABuilt 1975 · S/N 18502716N1062FSale Reported · Independence, ORSale reportedBuilt 1975 · S/N 18502718N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N1074FNorth River Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502730N1076FCavu Clearing LLC · Center Harbor, NHS/N 18502732N1077ABabcock Mark E · Auburn, WABuilt 1977 · S/N 18503156N1077FScileppi Gregory S · Sea Island, GABuilt 1975 · S/N 18502733N1078FWilliams Casey D · Wasilla, AKBuilt 1975 · S/N 18502734N107LHale Mitchell D · Chugiak, AKBuilt 1978 · S/N 18503535N107TYThornock Ty D · Shawano, WIS/N 18502836N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149N1084FSiktberg Timothy J · Nashville, TNBuilt 1975 · S/N 18502739N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564N1089FWells Thomas J · Big Lake, AKBuilt 1975 · S/N 18502744N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505N108GWPope James D · Clarkston, WAS/N 32683N1095FEggart Lawrence D · Nome, AKS/N 18502750N1099FSaal Christopher J · Anchorage, AKBuilt 1975 · S/N 18502754N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513
Back to AD 2020-21-22