OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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

N5766JVan Hoogmoed Andrew P · Turlock, CABuilt 1980 · S/N 17273834N5766TJanson Flying Service Inc · Wadena, MNBuilt 1964 · S/N 17251666N5767BBarker Ski LLC · Big Lake, AKBuilt 1956 · S/N 33767N5767JValiair Limited Co Trustee · Casper, WYBuilt 1971 · S/N 21059467N5767RSelf Averill L · Campbell, TXBuilt 1965 · S/N 17253436N5768AGowing Glyn Thomas · Longview, TXBuilt 1956 · S/N 28368N5768CJones Gary A · Huron, SDBuilt 1950 · S/N 19722N5768GBilton Nicholas J · Bozeman, MTBuilt 1969 · S/N 15071268N5768JHaag Walter G · Fall City, WABuilt 1971 · S/N 21059468N5768RAllenray Corp · Otsego, MIBuilt 1965 · S/N 17253437N5768TCrouse Sheldon · Mount Pleasant, NCBuilt 1964 · S/N 17251668N5769BOgorman Errol M · Festus, MOBuilt 1956 · S/N 33769N5769GHarper William M Jr · Foley, ALBuilt 1969 · S/N 15071269N5769JRegistration Pending · Derby, KSRegistration pendingBuilt 1974 · S/N 18263527N5769RLatimer Francis E · Washingtonville, NYBuilt 1965 · S/N 17253438N5770GVoller Jim A · Strasburg, NDS/N 15071270N5770RFurge David T · Brookton, MEBuilt 1965 · S/N 17253439N57711Moss Donald C Jr · Morristown, TNBuilt 1983 · S/N 18268335N5771AHunt Jack D · Wilmington, NCBuilt 1956 · S/N 28371N5771BMorris Jerry W · Deer Trail, COBuilt 1956 · S/N 33771N5771JRegistered aircraftBuilt 1971 · S/N 21059471N5771RWilson Bach Myrl · Piedmont, SCBuilt 1965 · S/N 17253440N5772ALawlor Stephen M · Saint Joseph, MOBuilt 1956 · S/N 28372N5772GBean Dale R · Moreno Valley, CABuilt 1969 · S/N 15071272N5773AMelton James A · Mayflower, ARBuilt 1956 · S/N 28373N5773REnev Ivan E · Wood Dale, ILS/N 17253442N5774ALoughney Michael L · Indialantic, FLBuilt 1956 · S/N 28374N5774BAshiku Phillip · Ukiah, CABuilt 1956 · S/N 33774N5774GHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071274N5774RBallard Thomas L · Seguin, TXBuilt 1965 · S/N 17253443N5775AWeber Francis W Jr · Le Sueur, MNBuilt 1956 · S/N 28375N5775BBrindley Paul A · Plainwell, MIS/N 33775N5776BTjp@Jax Inc · Zephyrhills, FLBuilt 1956 · S/N 33776N5776CBuchanan William A · Snohomish, WABuilt 1950 · S/N 19730N5776GWilliams Timothy · Byron, GABuilt 1969 · S/N 15071276N5776RKatri Thomas L · Conroe, TXBuilt 1965 · S/N 17253445N5776TClark Jeffrey Wayne · Piedmont, MOBuilt 1964 · S/N 17251676N5777BScrews Elisha J · Owens Cross Roads, ALBuilt 1956 · S/N 33777N5777CZola Harry · Wasilla, AKS/N 19731N5777GZawtocki Ronald · Little Falls, NYBuilt 1969 · S/N 15071277N5777RSumner Gary W · Knoxville, TNBuilt 1965 · S/N 17253446N5778JTwin Falls Fliers Inc · Twin Falls, IDBuilt 1974 · S/N 18263530N5778TGreen Hornet Aviation LLC · Bloomsburg, PABuilt 1964 · S/N 17251678N5779GChapman Jeremy R · Niagara Falls, NYBuilt 1969 · S/N 15071279N5779JBeavers Air LLC · Fort Walton Beach, FLBuilt 1971 · S/N 21059479N5779TArdmore Aviation LLC9667 · Novelty, OHBuilt 1964 · S/N 17251679N577CDSeger Properties Ltd · Fort Loramie, OHBuilt 1969 · S/N P20600609N577CTShaw Air Limited LLC · Mansfield, PAS/N 18266546N577TCCrimson Aviation LLC · Helena, MTBuilt 1980 · S/N 18267564N5780GAlvarez Faust M · Helena, MTBuilt 1969 · S/N 15071280
Back to AD 87-20-03 R2