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

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.

N2753QFull Throttle Aviation LLC · Terlingua, TXS/N 18257953 N2753SSlownlow LLC · Kalispell, MTBuilt 1967 · S/N 15066653 N2753VSirius Real Estate LLC · Murphys, CABuilt 1975 · S/N 177RG0681 N2753XStorer Charles E · Payette, IDBuilt 1965 · S/N 18051553 N2754EGulf Coast Helicopters Inc · Pearland, TXBuilt 1978 · S/N 17271315 N2754FOtter Mark E · Warrensburg, MOBuilt 1965 · S/N 18256854 N2754LThompson John D · Amana, IABuilt 1967 · S/N 17255954 N2754SGaddis Rebekah J · Valley City, OHBuilt 1967 · S/N 15066654 N2754UKirkpatrick Dan C · Little Rock, ARBuilt 1963 · S/N 17250354 N2755CR & B Aviation LLC · Oakland, MIBuilt 1955 · S/N 31902 N2755QBlessed With Wings LLC · Queen Creek, AZS/N 18257955 N2755XMcsheehy James B · Fallbrook, CABuilt 1965 · S/N 18051555 N2756DStewart James A · San Ramon, CABuilt 1952 · S/N 25298 N2756JSquatch Air LLC · Wasilla, AKBuilt 1969 · S/N 185-1506 N2756QLett Brian R · Eden Prairie, MNBuilt 1967 · S/N 18257956 N2756VWilson Elmer W · Enterprise, ALBuilt 1975 · S/N 177RG0682 N2757FNationwide Web Directory Ltd · Seattle, WABuilt 1965 · S/N 18256857 N2757QFive Seven Quebec Incorporated · Lake Stevens, WABuilt 1967 · S/N 18257957 N2757UUt Lightsport One LLC · Uintah, UTBuilt 1963 · S/N 17250357 N2757VRasnake Larry J · Charlotte, NCBuilt 1975 · S/N 177RG0683 N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168 N2758JSoutiere Theresa Yvette · Juneau, AKBuilt 1975 · S/N A1500588 N2758SBogner Edward R · Santa Cruz, CABuilt 1967 · S/N 15066658 N2758VRichey Reginald Wade · Lincoln, NMBuilt 1975 · S/N 177RG0684 N2758XAerotechniques LLC · South Kent, CTBuilt 1965 · S/N 18051558 N2759CHillegeist Tracy L · Beverly, KSBuilt 1954 · S/N 26303 N2759JNg Byron · Foster City, CAS/N A1500589 N2759VRedwing Aviation LLC · San Antonio, TXBuilt 1975 · S/N 177RG0685 N275DMMaxfield Douglas R · Chico, CABuilt 1975 · S/N 18052558 N275FState Of Alaska Department Of Public Safety · Anchorage, AKS/N U20605207 N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631 N275HPRich Aviation Services LLC · Fort Worth, TXBuilt 1976 · S/N 18265173 N275ZZWardell Robert · Montrose AuNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 18503238 N2760COwens Gary R · Talkeetna, AKBuilt 1954 · S/N 26304 N2760SBond Doyle G · Walker, LABuilt 1967 · S/N 15066660 N2760UAnderson Justin Charles · Rockingham, NCS/N 17250360 N2760VFinish Line - N2760v LLC · Edmond, OKS/N 177RG0686 N2761CLangvardt Rawley J · Elkton, MDBuilt 1954 · S/N 26305 N2761GMartinell Justin E · Dell, MTBuilt 1959 · S/N 52061 N2761JAldrich Curtiss R · Big Oak Flat, CAS/N A1500590 N2761LMiller David L · Mineral City, OHBuilt 1967 · S/N 17255961 N2761UShafer Luke M · Wyoming, ILBuilt 1963 · S/N 17250361 N2762ADorman Richard E · Mesa, WABuilt 1957 · S/N 32849 N2762FFreflite LLC · Wilmington, DEBuilt 1966 · S/N 18256862 N2762LRock Communications · Rock Hill, SCBuilt 1967 · S/N 17255962 N2762UCapozzi Rocky P · Eagle River, AKBuilt 1963 · S/N 17250362 N2763DHammerton David · Olive Branch, MSBuilt 1952 · S/N 25305 N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863 N2763LTrent David A · Davin, WVBuilt 1967 · S/N 17255963 N2763SMoore Park · Byron, GABuilt 1967 · S/N 15066663

Back to AD 87-20-03 R2