OpenAirDocs.org
AD 84-20-01

Registered aircraft · 26

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

N10TYMountain Peter W · Williams, AZBuilt 1971 · S/N 15127N121MWSale Reported · Zephyrhills, FLSale reported, pending cancellationBuilt 1970 · S/N 15080N14LTLake Richard T · Port Saint Lucie, FLS/N 15193N1515BChilhowee Soaring Association Inc · Benton, TNBuilt 1976 · S/N 15450N15BTZobell Edward A · California, MDBuilt 1972 · S/N 15236N15KSCichy Roger D · North Scituate, RIBuilt 1972 · S/N 15232N15LJNatke Gregory I · Manlius, NYBuilt 1969 · S/N 15031N15RCSnadecki Eric A · Fort Bragg, NCBuilt 1970 · S/N 15096N15XSSpencer Scott A · Brownsburg, INBuilt 1971 · S/N 15152N178KLohre Charles R · Cincinnati, OHBuilt 1970 · S/N 15062N18CFLevy Niv · Torrance, CABuilt 1972 · S/N 15187N253DJLuitjens Jacob Jelte · Lagrange, GABuilt 1970 · S/N 15026N291WHaynes Michael J · Lenexa, KSS/N 15021N292WMWashburn Gordon L · Lakeland, FLBuilt 1970 · S/N 15076N33RDVarvarosky Chris G · Columbus, OHS/N 15129N3907BCoombes Leroy D · York, SCS/N 15134N484SAPrather David W · Cameron Park, CABuilt 1970 · S/N 15063N615PLipscomb James W · Salt Lake City, UTBuilt 1971 · S/N 15133N623Noodergraaf Alexander A · Concord, NHBuilt 1970 · S/N 15073N7240PHouseknecht Thomas J · State College, PABuilt 1969 · S/N 15022N8178Carmel Paul A · Santa Clara, CABuilt 1970 · S/N 15039N827Schirmer Dwight S · Milford, MABuilt 1973 · S/N 15282N8465Grieve Shane M · Fort Worth, TXS/N 15075N858Davenport John P · Redmond, WAS/N 15231N998EELance Scott B · Winchester, CAS/N 15195N99AHAdrian Soaring Club · Belleville, MIBuilt 1971 · S/N 15135
Back to AD 84-20-01