OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N195DFDickey Eldon Dewayne · Richmond, TXBuilt 1950 · S/N 7511N195DKMueller Dale H · Payson, AZBuilt 1950 · S/N 7615N195DMMcguire Dennis B · Howell, MIBuilt 1951 · S/N 7678N195DPPhilyaw David Arthur · Saint James, MOS/N 16149N195DRRegistration Pending · Danville, CARegistration pendingBuilt 1949 · S/N 7390N195DSAbq421 LLC · Los Ranchos, NMBuilt 1948 · S/N 7272N195DTAlldredge Aviation · Auburn, WABuilt 1948 · S/N 7287N195DYWheaton Clay D · Orchard Park, NYBuilt 1952 · S/N 7878N195DZKozura Bret T · Wellsville, PABuilt 1953 · S/N 16077N195ELEllingham Jeffrey B · Perry, GABuilt 1953 · S/N 16039N195FAerostream Services LLC · Cincinnati, OHBuilt 1950 · S/N 7493N195FYGarin Alan Thomas · Waxhaw, NCBuilt 1953 · S/N 16050N195GSalter Kevin L · Garden City, KSBuilt 1947 · S/N 7047N195GEThaxton Robert W · Rifle, COS/N 7600N195GSFairfield Eugene D · Wiscasset, MEBuilt 1962 · S/N 15059755N195GTTrebon Gregory L · Port Orange, FLS/N 16055N195GWRising Jonathan D · Ocala, FLBuilt 1949 · S/N 7455N195HCalef Jere R Trustee · Mojave, CABuilt 1948 · S/N 7200N195HADodge Inc · Wilmington, DEBuilt 1965 · S/N 7438N195HJJorgensen Bryan H · Wadsworth, OHBuilt 1952 · S/N 7880N195JGores Thomas J · Franklin, WIBuilt 1954 · S/N 16123N195JAR H K Of Kansas Inc · Overland Park, KSBuilt 1950 · S/N 7504N195JBMoore Glenn C · Elkhart Lake, WIS/N 7220N195JDBoswell Kurt R · Renton, WAS/N 7603N195JFDark Ark Enterprises LLC · Bentonville, ARBuilt 1950 · S/N 7576N195JLLambert James A · Enumclaw, WABuilt 1952 · S/N 7944N195JPJacobs David E · Saint Georges, DEBuilt 1951 · S/N 7673N195JSScholl Jonathan W · Mckinney, TXBuilt 1952 · S/N 7872N195JWFroes Jonathan C · Little Elm, TXBuilt 1953 · S/N 16094N195KPlymate Jeffrey L · Sandy, ORS/N 7867N195KBHubner Leigh Andrew · Locust Grove, GABuilt 1952 · S/N 7949N195KJGilbride Richard L · Ringgold, GABuilt 1952 · S/N 7800N195KRKiser Richard K · Grottoes, VABuilt 1948 · S/N 7160N195KSKalina David A · Johnstown, PABuilt 1950 · S/N 7582N195KWHenkemeyer Joseph S · Cave Creek, AZBuilt 1948 · S/N 7242N195LBMmm Friemel Inc · Hereford, TXBuilt 1951 · S/N 7703N195LCWindsock Holdings LLC · Amarillo, TXS/N 16144N195LGInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7303N195LNGrones John G · Port Orange, FLS/N 7824N195LSRicks Aviation Adventures LLC · Grand Forks, NDBuilt 1947 · S/N 7051N195LVHughes David L · Uintah, UTS/N 7813N195LWSmiley Neil G · Clover, VABuilt 1954 · S/N 16126N195MJLutz Roald F · Sandia Park, NMBuilt 1952 · S/N 7882N195MKScholten Calvin B · Lakeland, TNBuilt 1952 · S/N 7907N195MMCasa Acquistions LLC · Winter Haven, FLS/N 16032N195MSMccombs Dale A · Midlothian, TXBuilt 1952 · S/N 7994N195NHewitt Roger L · Kent, WABuilt 1953 · S/N 16075N195PDiamond B Farms Trucking Inc · Gamaliel, KYBuilt 1948 · S/N 7218N195PCBurson Anthony W · Cape Charles, VABuilt 1954 · S/N 16140N195PDDougherty Paul D Jr · Bethel, PABuilt 1950 · S/N 7460
Back to AD 87-20-03 R2