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.

N9968VCynthiana Flying Group Corp · Cynthiana, KYBuilt 1974 · S/N 17264586N9968XEagley Ronald A · Anchorage, AKBuilt 1961 · S/N 185-0168N99697Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276494N9969ARegistration Pending · Frostproof, FLRegistration pendingBuilt 1950 · S/N 19628N9969BGreenwalt Bert · Jonesboro, ARBuilt 1982 · S/N 172RG1101N9969CAttitude Indicators LLC · Allegan, MIBuilt 1978 · S/N R18200494N9969THatch Industries LLC · Snowflake, AZS/N 18253069N9969VCosta William · Farmington Hills, MIBuilt 1974 · S/N 17264587N996AKSierra Sky Aviation LLC · Kalispell, MTBuilt 1970 · S/N U20601519N996MWWiehl In The Sky LLC · Mount Juliet, TNBuilt 1973 · S/N 17262434N99700Lee Rich · Carlsbad, CABuilt 1985 · S/N 17276496N99709Long Island Aviators LLC · Seaford, NYBuilt 1985 · S/N 17276498N9970AKingsley Kiman J · Miller, MOBuilt 1950 · S/N 19589N9970VSpalding Flying Club LLC · Griffin, GABuilt 1974 · S/N 17264588N9970ZHartland Aviation LLC · Hartland, MIBuilt 1983 · S/N U20606783N99712Nesher Aviation II LLC · Jacksonville, FLBuilt 1985 · S/N 17276499N99715N99715 LLC · Wheeling, ILS/N 17276501N9971AZilinsky Robert F · Willowbrook, ILBuilt 1950 · S/N 19629N9971EGuerrero-Reyes Fernando G · Princeton, NJBuilt 1979 · S/N 17272304N9971NCranford Billy J · Wasilla, AKBuilt 1975 · S/N 18052626N9971TGuardalabene Anthony E · Lake Havasu City, AZBuilt 1960 · S/N 18253071N9971VWalters Aaron R · Estes Park, COBuilt 1977 · S/N R1722358N99725Holladay Aviation LLC · Jacksonville, FLBuilt 1985 · S/N 17276502N9972ARegistration Pending · Seattle, WARegistration pendingBuilt 1950 · S/N 19553N9972NChandler E H Jr · Ozona, TXBuilt 1975 · S/N 18052627N9972VMotley Charlotte J · Summerdale, ALBuilt 1974 · S/N 17264590N9973AGuillebeau Instruction Inc · Sherwood, ARS/N 19554N9973BMajor Air LLC · Charleston, SCBuilt 1982 · S/N 172RG1103N9973FMayer Larry A · Billings, MTBuilt 1960 · S/N 15050919N99744Christiansen Aviation LLC · Wilmington, DEBuilt 1985 · S/N 17276503N9974BAppalachian Aviation LLC · Harrisonburg, VABuilt 1982 · S/N 172RG1104N9974ERajdl Alan · Deer River, MNBuilt 1985 · S/N 18268477N9974MAllmen David B · Valley Center, CABuilt 1978 · S/N U20604624N99750Kool Wings Leasing LLC · Indianapolis, INBuilt 1985 · S/N 17276504N99759Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276506N9975TLancello Dylan E · Townsend, MTBuilt 1960 · S/N 18253075N99765Tactical Intergriated Training Solutions LLC · Colorado Springs, COBuilt 1985 · S/N 17276507N9976AWestern Air Express LLC · Helena, ALBuilt 1950 · S/N 19336N9976BArend Robert E Jr DBA · Mark Center, OHBuilt 1957 · S/N 34376N9976GAbernethy Joe H · Hickory, NCBuilt 1973 · S/N A1500476N9976MBrush Wesley A · Sparks, NVBuilt 1978 · S/N U20604626N99770Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276508N9977AMielke Frederick J III · Plains, MTS/N 19337N9977EDunlap Cameron · Campbell, NYBuilt 1958 · S/N 34853N9977JBoening Bros Dusting & Spraying Inc · Floresville, TXBuilt 1982 · S/N T18803906TN9977TGastineau Patrick S · Bothell, WABuilt 1960 · S/N 18253077N9977VLunceford James A · Stanchfield, MNBuilt 1974 · S/N 17264595N99783Alexander Todd · Westhampton, MABuilt 1985 · S/N 17276510N9978BReal Brian M · Anchorage, AKBuilt 1957 · S/N 34378N9978ELagasse Robert · Wolcott, CTBuilt 1985 · S/N 18268478
Back to AD 87-20-03 R2