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.

N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474 N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475 N7775KMarsh John E · Washington, DCS/N 18053071 N7775TSheaffer Hayden L · Lititz, PABuilt 1960 · S/N 47375 N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476 N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194 N7776XVista I Inc · Smithville, OHBuilt 1961 · S/N 17248276 N7777ALibby Stephen R Trustee · Anchorage, AKBuilt 1978 · S/N U20604391 N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334 N7777SHood Company LLC · Nashville, TNBuilt 1972 · S/N 21059611 N7778Carpenter Darrell W · Midland City, ALBuilt 1973 · S/N 177RG0349 N7778UAngel Del Mar LLC · Park City, UTBuilt 1964 · S/N 17251778 N7779AHendry Rickey W · Apple Springs, TXBuilt 1956 · S/N 32676 N7779FSmith Brian · Richmond, INBuilt 1966 · S/N 15063879 N7779KSeventy Six Juliet LLC · Oakland, CABuilt 1976 · S/N 18052728 N777ADLeithead Bruce O · Stone Mountain, GABuilt 1958 · S/N 55502 N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695 N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156 N777CASwamp Skies LLC · North Miami, FLS/N 17268259 N777CFCp Aviation LLC · Pasco, WABuilt 1977 · S/N 21062059 N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373 N777DUSc Infinities LLC · Dover, DEBuilt 1971 · S/N 17259854 N777FWLewis Kent · Lake Oswego, ORBuilt 1974 · S/N 21060167 N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276 N777GTShillings Phillip J · Goldthwaite, TXS/N 21058339 N777HKPremiere Aviation LLC · Evansville, INBuilt 1976 · S/N 18265047 N777HMMusser Harold R · Cody, WYBuilt 1980 · S/N 18504048 N777HRLansing Skylane Inc · Orland Park, ILBuilt 1981 · S/N 18267963 N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835 N777JKGeoterra Inc · Eugene, ORS/N 21064714 N777KSBrahm Robert D · Mercer Island, WABuilt 1978 · S/N 18266736 N777MBCullen Maryrose · Longmont, COBuilt 1977 · S/N R1722601 N777NTN777nt LLC · Fort Mill, SCBuilt 1975 · S/N 21060972 N777NYJohanson Jason M · Groveland, CAS/N U20605051 N777RKing Winn K · Gladewater, TXBuilt 1972 · S/N 21059551 N777RGLow Matthew N · Clearwater, FLBuilt 1968 · S/N 18258774 N777RRChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21061729 N777SNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N P3370325 N777SZMullen John J Jr Trustee · Henderson, NVBuilt 1970 · S/N 21059265 N777TVTop Ag Inc · Colby, KSBuilt 1977 · S/N 18265360 N777TWMcdonald Timothy J · Daytona Beach, FLBuilt 1977 · S/N R1722585 N777UMMahlik Michael A · Casco, WIS/N 17275405 N777VJTucker Billy J · Arley, ALBuilt 1979 · S/N R18200870 N777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEBuilt 1970 · S/N 21059376 N777WRFoley James V · Houston, TXBuilt 1962 · S/N 18253913 N777YTKeyt LLC · Missoula, MTBuilt 1981 · S/N 18268029 N777ZCDiversified Refrigeration Co · Lino Lakes, MNBuilt 1966 · S/N 18256985 N7780AWhitmore Jay R · Anchorage, AKBuilt 1957 · S/N 32677 N7780FDuquette Stephen R · Fenton, MIS/N 15063880 N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480

Back to AD 87-20-03 R2