AD 87-20-03 R2

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

N91CCDeep Creek Aviation LLC · Ashburn, GABuilt 1978 · S/N 18266433N91DAJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 18266836N91DJNola Knewbees LLC · New Orleans, LABuilt 1974 · S/N 18262605N91DMHead Joseph A · Fairbanks, AKBuilt 1976 · S/N 18503137N91GEGas Aviation LLC · Decatur, TNS/N P3370276N91HLWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1982 · S/N 15285648N91LPDreisewerd William · Winfield, MOBuilt 1984 · S/N 18268423N91LVWoodfield Terry J · Pearland, TXBuilt 1980 · S/N 172RG0281N91MWSub C Air LLC · Spring, TXS/N 18504333N91PAHigh Wing Air LLC · Arnold, MOBuilt 1972 · S/N 17260792N91PCChay Dan B · Kenai, AKBuilt 1959 · S/N 50461N91PHJulien John · Houghton, MIS/N 18502325N91PMRunrich LLC · Newport News, VABuilt 1974 · S/N 17264113N91QSFly Diablo Inc · North Wales, PABuilt 1976 · S/N 17268167N91RBlack Pilots Of America Detroit Chapter · Detroit, MIS/N 15067793N91WAStevens James L · Carrollton, GABuilt 1955 · S/N 28090N92000Clift Robert E · Anchorage, AKBuilt 1969 · S/N 18259991N92006Troughton Jill A · Spring Hill, FLBuilt 1973 · S/N 17261535N92009Will Dennis L · Clyde, MIBuilt 1969 · S/N 18259997N9200CShepard Philip A · Trophy Club, TXBuilt 1978 · S/N R18200443N9200GNoya Charles J · Albuquerque, NMBuilt 1971 · S/N 18260740N9200UCherry Hill Aviation Inc · Freetown, INBuilt 1976 · S/N 15078151N9200XCochreham Bryce O · Seibert, COBuilt 1962 · S/N 18253600N92013Burns Dale E · Kamiah, IDBuilt 1969 · S/N 18259999N92014Shotwell Land Management Co LLC · Jackson, MSS/N 17261538N92016Campbell Kevin T · Gretna, NEFirst renewal noticeBuilt 1969 · S/N 18260002N92018Mercenary Medical LLC · St George, UTBuilt 1969 · S/N 18260004N9201HSparkwizard LLC · Greenville, RIBuilt 1975 · S/N 17266012N92020Domaille Dennis C · Mammoth Lakes, CABuilt 1969 · S/N 18260006N92021Pisiak Sonny S · Queen Creek, AZS/N 18260007N92026Haltom Frances F · Alva, OKS/N 17261539N9202AWilson Alan Trustee · Waukesha, WIS/N 18963N9202TLander David W · Gilroy, CABuilt 1959 · S/N 50702N9202XNohrenberg Larry R · Jamestown, NDBuilt 1962 · S/N 18253602N92035Ford Daniel T · Warsaw, INBuilt 1973 · S/N 17261540N92039Newwing LLC · Freeland, WABuilt 1969 · S/N 18260014N9203CSamuel James F · Port Byron, NYS/N 31302N9203GStohr Jeffry M · Aberdeen, SDBuilt 1974 · S/N 18263392N9203TMartinson Douglas E · Nome, AKS/N 50703N9203UAlaskan Mariners Inc · Homer, AKBuilt 1976 · S/N 15078154N9203XPeru Projects Inc · Lincoln, NEBuilt 1962 · S/N 18253603N92049Put Ronald · Alameda, CABuilt 1969 · S/N 18260019N9204AConrad William A · Kaukauna, WIBuilt 1949 · S/N 18965N9204BMcelwain Floyd · Saint Joseph, MOBuilt 1958 · S/N 55004N9204GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801423N9204HTongass Air LLC · Ketchikan, AKBuilt 1977 · S/N 18503421N9204TDoner Daniel D · Highlands Ranch, COBuilt 1960 · S/N 50704N92050Tysky Air LLC · Arvada, COBuilt 1969 · S/N 18260020N92051Yardy Paul J · Caledon OntarioBuilt 1969 · S/N 18260021N92054Waterheat Inc · Anchorage, AKBuilt 1969 · S/N 18260023
Back to AD 87-20-03 R2