OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N53787Jones Carl L Jr · Edmond, OKBuilt 1975 · S/N 183-75N5378DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272553N5378ENuxoll Randy G · Eagle, IDBuilt 1978 · S/N 17271841N5378HFellman Peter A · North Chatham, MABuilt 1949 · S/N 16-185N5378KUnique Educational Experiences Inc · Signal Hill, CABuilt 1980 · S/N 17274087N5378LPeterson Dru J · Riverside, CABuilt 1968 · S/N 28-4684N5378WHargis Bookman LLC · Justin, TXBuilt 1962 · S/N 28-443N5378YRagwing Flyers LLC · Richmond, TXBuilt 1964 · S/N 18-8141N53791Maseman Paul A · Tucson, AZBuilt 1975 · S/N 887-76N53794Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274816N53797Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274819N5379SStevens Michael J Trustee · Park City, UTBuilt 1980 · S/N R18201561N5379YHandly William A · Arcola, MSBuilt 1964 · S/N 18-8142N537APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843760N537ACMacmillan John Jr · Chevy Chase, MDBuilt 2005 · S/N 999-2005N537CLAckerman Terry L · Brookings, SDBuilt 2001 · S/N 2176N537DMKrakoff Matthew · Massapequa, NYBuilt 1969 · S/N 30-1863N537FLHanson David Lawrence · Tucson, AZBuilt 1971 · S/N 28-7125367N537HPBarr Air Patrol LLC · Mesquite, TXS/N 18280031N537JHBuffington Matthew Hill · Highlands Ranch, COBuilt 1975 · S/N 533-75N537JPPerkins John D · Salem, NHS/N 06-537N537MAK2 Aviation LLC · Greenwood Village, COS/N 40.463N537MMMarshall Aviation Services Inc · Elkhart, INBuilt 1995 · S/N 1302N53800Blue Earth Flying Service LLC · Blue Earth, MNBuilt 1975 · S/N 321-75N53802Mcwhorter S Aaron · Whitesburg, GABuilt 1975 · S/N 880-75N53806Quaal Christian M · Sundance, WYFirst renewal noticeBuilt 1975 · S/N 184-75N5380LLane Joshua J · Eaton, COBuilt 1968 · S/N 28-4687N5380WManista Joseph G Jr · Hemet, CABuilt 1962 · S/N 28-445N53815Ag Solutions LLC · Garden City, KSS/N 546-75N53817Rittberger Beef Inc · Hermosa, SDBuilt 1975 · S/N 882-75N53818Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1975 · S/N 216-75N53819Seekins Ralph DBA · Fairbanks, AKS/N 201-76N5381PRiggs Michael · Yoder, COBuilt 1958 · S/N 24-432N5381TBlaes Christopher T · Gallatin, TNBuilt 1972 · S/N 32-7240106N53820Skylane Capital Group LLC · Seattle, WABuilt 1975 · S/N 547-75N53822American Patrols Inc · Midland, TXBuilt 1981 · S/N 17274821N53824Law C Scott · Oklahoma City, OKBuilt 1975 · S/N 884-75N5382DEagles Flying Club · Saint Charles, MOBuilt 1979 · S/N 17272556N5382FRose James A · Boston, MABuilt 1976 · S/N 32R-7680520N5382NHarrell Thomas · Ocala, FLBuilt 1982 · S/N 32-8224012N5382PBryant Ashley Kae · Fort Worth, TXBuilt 1958 · S/N 24-433N53830Rives Taylor J · Buffalo, WYBuilt 1975 · S/N 548-75N53834Morrison Dale C · Eloy, AZS/N 220-75N53837Anderson Gene S · Whitewater, MTBuilt 1975 · S/N 886-75N53838Euroaviation Inc Trustee · KematenBuilt 1975 · S/N 222-76N5383DTong Sheng Aviation LLC · Irvine, CABuilt 1979 · S/N 17272557N5383FN&T Investments LLC · Gulf Shores, ALBuilt 1976 · S/N 32R-7680521N5383KAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274088N5383LMo Landings LLC · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 28-4690N5383WHub City Aviation Academy LLC · Lubbock, TXBuilt 1962 · S/N 28-449
Back to AD 87-10-06 R1