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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N76EDFlying Hawks Ranch LLC · Bruning, NEBuilt 1968 · S/N P206-0487 N76HCHp Premier Solutions LLC · Lakeland, TNS/N 18262234 N76HFRgp Aviation LLC · The Villages, FLBuilt 1976 · S/N 33701729 N76HJAmalong Timothy M · Tucson, AZBuilt 1976 · S/N 17266809 N76HSDelgrosso Dennis W · Saranac, NYBuilt 1977 · S/N 17702642 N76HVScholz Francis M · Atchison, KSBuilt 1976 · S/N 15078633 N76JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1974 · S/N 17263122 N76JKKrajewski Jason · Portland, ORBuilt 1976 · S/N 177-02435 N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925 N76LGHeimbach Ann M · Duluth, MNBuilt 1976 · S/N 18052674 N76LJNelson Flyers Inc · Louise, TXBuilt 1966 · S/N 18051764 N76MAAnderson Daniel J · Campbellsport, WIFirst renewal noticeBuilt 1959 · S/N 55892 N76PHHarker James P · Forest Lake, MNS/N 18503142 N76RCN76rc LLC · Buckeye, AZS/N 18264691 N76RFWeiman David W R · Oregon, WIBuilt 1976 · S/N 18264735 N76RJMother Earth Flight Inc · Wilmington, DES/N 18268494 N76RRReynolds Joseph I · Irving, NYBuilt 1959 · S/N 57051 N76SCBeaver Creek Adventures LLC · Bangor, MEBuilt 1981 · S/N 18504206 N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711 N76STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1975 · S/N 15077396 N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025 N76TNC & D Aircraft LLC · Inver Grove, MNBuilt 1966 · S/N 18257836 N76WGCooper David J Trustee · San Francisco, CABuilt 1964 · S/N 18255867 N76XPCag Interional Inc DBA · Longmont, COBuilt 1976 · S/N R1722084 N76YSEstrada Ernesto Alejandro · Yuma, AZBuilt 1965 · S/N 15062483 N7700FClairy Scott M · Justin, TXBuilt 1966 · S/N 15063800 N7700HBrensing Steve E · Stafford, KSBuilt 1972 · S/N 18261304 N7700UJarvis Tree Service Inc · Heber Springs, ARBuilt 1964 · S/N 17251700 N7700XRule Paul Crane Trustee · Wapato, WABuilt 1961 · S/N 17248200 N7701FRegistered aircraftBuilt 1977 · S/N 18503245 N7701UIyer Sundaresh R · Northborough, MABuilt 1964 · S/N 17251701 N7702KRose Hugh S · Fairbanks, AKBuilt 1976 · S/N 18052705 N7702TNablo Dustin · Haddam Neck, CTS/N 47302 N7702VBrown Warren C · Pasadena, CABuilt 1976 · S/N 177RG0905 N7703FGonzales Donald M · Columbia Station, OHS/N 15063803 N7703TRegistered aircraftBuilt 1972 · S/N 18502056 N7704UAllen Philip · Portland, ORBuilt 1976 · S/N 15077826 N7704XStark Linda L · Arroyo Grande, CABuilt 1960 · S/N 17248204 N7705FEisel Joseph D · Dexter, ORBuilt 1966 · S/N 15063805 N7705UCaldwell Evan-James Gray · Camano Island, WAS/N 17251705 N7706XAircaft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1960 · S/N 17248206 N7707AGay Chris · Anchorage, AKBuilt 1956 · S/N 32604 N7707TAmerican Petro Inc · Ball Ground, GABuilt 1960 · S/N 47307 N7707UMeese Brian D · Conroe, TXBuilt 1964 · S/N 17251707 N7708AFrelin Josef J · Anchorage, AKS/N 32605 N7708UDahle Jacob J · Morristown, MNBuilt 1964 · S/N 17251708 N7709FChiang Yucheng · Glenview, ILBuilt 1966 · S/N 15063809 N770CBTeton Avjet LLC · Driggs, IDBuilt 1976 · S/N R172-2175 N770CDCunningham Campers & Rvs · Clarksville, INBuilt 1976 · S/N 33701774 N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569

Back to AD 87-20-03 R2