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.

N8294FWalters Craig S · Lake City, FLS/N 15064394 N8294SLogtime Flight LLC · Lancaster, TXBuilt 1965 · S/N 15061894 N8294XFranco Stephen B · Chicago, ILBuilt 1961 · S/N 17248794 N8295AHairston Marvin A · Peck, IDBuilt 1952 · S/N 25147 N8295BSkywriters Inc · Ferndale, WABuilt 1957 · S/N 36095 N8295EFrump Leasing Inc · Newburgh Heights, OHS/N 17272181 N8295UCrawfish Co LLC · Starkville, MSBuilt 1964 · S/N 17252195 N8296EMosbach Rene A · Sandia, TXBuilt 1979 · S/N 17272182 N8296GKiehl Austin J · Winnett, MTBuilt 1973 · S/N 18801293 N8297BSchler Joseph B · Reno, NVBuilt 1957 · S/N 36097 N8297EConaway Scott J · Traverse City, MIBuilt 1979 · S/N 17272183 N8297SBergmann Joshua A · Menomonie, WIBuilt 1965 · S/N 15061897 N8297UMcburney Richard O · Hudson, NCBuilt 1964 · S/N 17252197 N8297ZMartinez Gabriel M · Santa Fe, NMBuilt 1963 · S/N 205-0297 N8298EAberdeen Flying Service · Aberdeen, SDBuilt 1979 · S/N 17272184 N8298FAustin Leslie M · Greenville, INBuilt 1966 · S/N 15064398 N8298UCollins Roberto · Naples, FLBuilt 1976 · S/N 15077915 N8299AStevenson James W · Oregon, WIBuilt 1952 · S/N 25151 N8299BJohnston Keith G · Honolulu, HIBuilt 1951 · S/N 36099 N8299ELondon Corbin Airport Board · London, KYBuilt 1979 · S/N 17272185 N8299SMcauliffe John P · Livonia, MIBuilt 1965 · S/N 15061899 N8299XBeail Herschel D · Quincy, CAS/N 17248799 N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819 N829BGGipson Robert E · Port Byron, ILBuilt 1968 · S/N 17700667 N829PJMidwestern Twang Communications LLC · Evanston, ILBuilt 1970 · S/N 17701534 N829TJJ T Airshows · Slidell, TXBuilt 1953 · S/N 16048 N82ADAdams Aircraft LLC · Wilmington, DEBuilt 1961 · S/N 18253753 N82BAMcilnay Brian S · Athens, TNBuilt 1981 · S/N 18268084 N82BGGrimshaw Brian Trustee · Long Beach, CABuilt 1964 · S/N 18255427 N82CCDenrow Limited Lc · Shawnee, OKBuilt 1975 · S/N 18264066 N82CTCoelho Gabriel P · Chowchilla, CABuilt 1969 · S/N 18259804 N82DZJosephine Air LLC · Castle Rock, WABuilt 1978 · S/N 18266752 N82ESkymaster Mods & Parts LLC · Castalian Springs, TNBuilt 1973 · S/N P3370126 N82EDRodriguez Rolando · Harlingen, TXBuilt 1973 · S/N 15075663 N82EPPosav Holdings LLC · Zephyrhills, FLBuilt 1978 · S/N 17271353 N82ERMidwest Airmotive Inc · Mount Sterling, KYBuilt 1978 · S/N R18200225 N82FBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N 18263094 N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401 N82HSAdventist World Aviation · Wilson, NCBuilt 1971 · S/N 18260814 N82JWGaines Joseph M · Niceville, FLBuilt 1980 · S/N 18053162 N82KYKentucky Department Of Aviation · Frankfort, KYS/N 18267092 N82LWMuskox Ministries · Fairbanks, AKBuilt 1973 · S/N U20602054 N82MEHutt George H III · Stratham, NHBuilt 1975 · S/N 18264089 N82MGSkymasters LLC · Olathe, KSBuilt 1967 · S/N 337-0659 N82MNDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N R1722014 N82NGallant James II · Scottsville, KYS/N 33538 N82NACoduto Billy Mark · Shelbyville, TNS/N 18264607 N82PAHart Michael Anthony · Rockford, ILFirst renewal noticeBuilt 1986 · S/N 18268586 N82SLHanus Logan D · Kenyon, MNS/N 18257976 N82TLRegistration Pending · Roscoe, ILRegistration pending, pending cancellationS/N 18263775

Back to AD 87-20-03 R2