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.

N7655XMedical Surgical Clinic LLC · Fort Scott, KSBuilt 1960 · S/N 17248155 N7656MSparrowhawk Aviation · Manvel, TXFirst renewal noticeBuilt 1959 · S/N 55956 N7656XMiranda Maria J · Santa Maria, CABuilt 1960 · S/N 17248156 N7657GDodd Brian G · Mount Vernon, SDBuilt 1973 · S/N 15074711 N7657TGuarno Adam C · Milton, FLBuilt 1960 · S/N 47257 N7657XGordon Christopher R · Moose Pass, AKBuilt 1960 · S/N 17248157 N7658AWest Michigan Aviation Inc · Kalamazoo, MIBuilt 1956 · S/N 32555 N7658URegistration Pending · Oregon City, ORRegistration pendingBuilt 1976 · S/N 15077784 N7659TKano Yoshio W · Barrington, ILBuilt 1960 · S/N 47259 N765MJBusch Renard · Castro Valley, CABuilt 1967 · S/N 18258116 N765SRRichard Stephen R · Delphos, KSBuilt 1979 · S/N 18267164 N7660GKorn Clifton A · Hayward, WIBuilt 1970 · S/N 17259360 N7660XAdams John S · Roselle, ILBuilt 1960 · S/N 17248160 N7661AMiller Bradley · Joliet, MTBuilt 1956 · S/N 32558 N7661MPaul Gregory A · Overland Park, KSBuilt 1959 · S/N 55961 N7661USweitzer Cameron D · Warrensburg, MOBuilt 1976 · S/N 15077787 N7662GB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N 17259362 N7662KBredthauer Glen · Hastings, NEBuilt 1976 · S/N 18052696 N7662TTriana David · Goose Creek, SCBuilt 1960 · S/N 47262 N7662UMcintyre James C · Bethlehem, PABuilt 1976 · S/N 15077788 N7663ATovsen John T · Anchorage, AKBuilt 1956 · S/N 32560 N7663MRashid Shahn S · Clear, AKBuilt 1959 · S/N 55963 N7663TTc Flight LLC · Lincoln, NES/N 47263 N7664MMalinchak Louis Jr · Bristow, OKBuilt 1959 · S/N 55964 N7665UGazca Aaron Armando · Burgaw, NCS/N 15077791 N7665XAvz Aviation.Inc · Knoxville, TNS/N 17248165 N7666ACournoyer Constance L · Ellsinore, MOBuilt 1956 · S/N 32563 N7666GHudson Daryl J · Redwood Valley, CABuilt 1970 · S/N 17259366 N7666XSidaras Al · Salado, TXBuilt 1960 · S/N 17248166 N7667GBrooks Alan G · Kernersville, NCBuilt 1970 · S/N 17259367 N7667MGier James C · Belgrade, MTBuilt 1959 · S/N 55967 N7667THembree Roy C Jr · Covington, GABuilt 1960 · S/N 47267 N7667XMatthews Thomas A · Belvidere, NJBuilt 1960 · S/N 17248167 N7668ASpevacek William E · Geraldine, MTBuilt 1956 · S/N 32565 N7668KAviation Enterprises Aircraft Sales LLC · Springfield, MOS/N 18052697 N7668MNeal Daniel L · Morgan Hill, CABuilt 1959 · S/N 55968 N7668THoff Stephen R · Wilson, WYBuilt 1960 · S/N 47268 N7668UMarchbanks William W · Hillsboro, ORBuilt 1976 · S/N 15077794 N7668XEkerberg Mark J · Newton, KSBuilt 1960 · S/N 17248168 N7669GWingsleasing LLC · Wichita, KSBuilt 1970 · S/N 17259369 N7669M95 Contracting LLC · Leander, TXBuilt 1959 · S/N 55969 N766CPCity Of Cleveland · Cleveland, OHBuilt 1975 · S/N 172-66326 N766EETomaszewski John E · Oceanside, CABuilt 1970 · S/N 18260217 N766MHoddenbach Jim · Woods Cross, UTS/N 18501795 N766TWBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N 17274134 N766VNCagle Jonathan D · Mobile, ALBuilt 1957 · S/N 34561 N7670GPremier Aviation LLC · Philadelphia, MSBuilt 1970 · S/N 17259370 N7670UMatthews Christopher T · Gardnerville, NVS/N 15077796 N7670XLohrke James W · Converse, TXBuilt 1960 · S/N 17248170 N7671MWarren Robert Scott · Harrisburg, NCBuilt 1959 · S/N 55971

Back to AD 87-20-03 R2