OpenAirDocs.org
AD 90-21-08

Registered aircraft · 2,605

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:90-21-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-21-08')
  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 30999N101APatterson Mark T · Kodiak, AKBuilt 1959 · S/N 50486N1027XHarper Shawn · Bayfield, COBuilt 1954 · S/N 31205N102CDrain Alan K · Columbus, MTS/N 30501N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989N1044SHubbell Wallis E · Tucson, AZS/N 52829N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505N108GWPope James D · Clarkston, WAS/N 32683N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10URXtiri LLC · St George, UTBuilt 1955 · S/N 32184N11118Aircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1963 · S/N 18051230N1112TRegistration Pending · Soldotna, AKRegistration pendingBuilt 1964 · S/N 50713N111WFArnold Frank W · Senoia, GABuilt 1954 · S/N 31243N111WLCj Aero LLC · Fort Valley, VABuilt 1973 · S/N 18052407N112GCSkywagon Ventures LLC · Chapel Hill, NCBuilt 1973 · S/N 18052387N112SSOlsen John · Wasilla, AKS/N 18052510N113BHBighorn Airways Inc · Sheridan, WYBuilt 1967 · S/N 18051844N116AKLucas Kelly W · Wasilla, AKBuilt 1965 · S/N 18051469N1171TCurrier Dustan A L · Fairbanks, AKS/N 30363N1177SRoss Robert S · Pigeon, MIBuilt 1958 · S/N 50177N1180BAom Aircraft LLC · Wilmington, DEBuilt 1953 · S/N 30115N11896Mcginty Flying Service LLC · Jones, LABuilt 1977 · S/N 18052921N1189RM9 180 LLC · Delhi, LAS/N 30698N118RABroken Aero Inc · Dunnellon, FLBuilt 1967 · S/N 18051935N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683N121RDVickery Forest H · Tallahassee, FLS/N 18052053N123LJRegistered aircraftBuilt 1965 · S/N 18051526N1250MBlakley John · Cascade, IDBuilt 1963 · S/N 18051213N1250WScherff Lewis H Trustee · Inver Grove, MNBuilt 1964 · S/N 18051429N1251BJagow Charles Philip · Fairbanks, AKBuilt 1966 · S/N 18051756N12580White River Ag Spraying Llp · Newport, ARBuilt 1964 · S/N 18051458N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772N126MSNance Cattle Co · Birney, MTBuilt 1964 · S/N 18051373N128SWRegistered aircraftBuilt 1966 · S/N 18051699N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806N131YBeli Christopher J · Oregon, OHS/N 18052073N13297Borchers Lee A Trustee · Independence, ORBuilt 1980 · S/N 18053167N132DMWilliams Robin M · Belgrade, MTBuilt 1975 · S/N 18052628N13500Caldwell Bob · Columbus, MSBuilt 1980 · S/N 18053168N135DMHarris Michael G · Spokane, WABuilt 1976 · S/N 18052635N1365BSholton Birgitte · Wasilla, AKBuilt 1971 · S/N 18052228N13MCMathison Neil James · Solon Springs, WIBuilt 1974 · S/N 18052444
Back to AD 90-21-08