Registered aircraft · 72,001

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N2588MN-J Aviation LLC · Forest, VAS/N 32R-7880066 N2588POkonek Kellie L · Girdwood, AKBuilt 1955 · S/N 18-4332 N2588TAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2006 · S/N T20608590 N2588WJohnson Mitchell R · Bismarck, NDBuilt 1965 · S/N 3280 N2589WHart Christian L · Highland Village, TXBuilt 1965 · S/N 942 N258AKThompson Nick · Eagle, AKBuilt 1994 · S/N 1258 N258ALLong Jeffrey · Dothan, ALBuilt 1976 · S/N 28-7615365 N258BWEastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17274811 N258CVandelay Industries I Inc · Wilmington, DEBuilt 1999 · S/N 2014 N258CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881356 N258DLExtapa LLC · Wilmington, DEBuilt 2012 · S/N 2250 N258ERLewis Carlos Brandon · Indian Mound, TNBuilt 1978 · S/N 17270891 N258MEGolf Delta Charlie LLC · Baton Rouge, LABuilt 2000 · S/N 18280768 N258MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881451 N258MMGreene Leon Alfred Jr · Van Nuys, CABuilt 2007 · S/N 91442 N258RAReynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 17270533 N258REEbel Roy J · Hot Springs, SDBuilt 2012 · S/N 82515 N258SBSkyfusion II LLC · Atlanta, GABuilt 1969 · S/N 28R-35641 N258SCBlue Border LLC · Blue Earth, MNBuilt 1982 · S/N 32-8306001 N258SHWilmarth Russell · Alton Bay, NHBuilt 2008 · S/N 826 N258VF1r14a LLC · Huntersville, NCBuilt 2004 · S/N 34 N2590QConant Edward · The Woodlands, TXBuilt 1977 · S/N 28R-7737038 N2590WWheeler James N · Shreveport, LABuilt 1965 · S/N 943 N2590XC B W Landscaping Construction Co Inc · Framingham, MAS/N 679M N2590ZWollaston Dean E · Hazel Green, WIBuilt 1977 · S/N 260-77 N2591HRaile Randall J · Benkelman, NEBuilt 1979 · S/N 18-8009003 N2592PRogers Lee B · Anchorage, AKBuilt 1955 · S/N 18-4336 N2592SSchaller Lee · New Athens, ILS/N 18-7909166 N2593RWeatherly Lloyd W · Wittmann, AZS/N 28-5654 N2593WUehlin Bradley S · Danbury, NEBuilt 1965 · S/N 3282 N2593ZGuillen Gregorio J · Phillipsburg, NJS/N 27-8154007 N2594WMcclure Richard A · Victoria, TXBuilt 1965 · S/N 945 N2595WReid Lois M · Dallas, TXBuilt 1965 · S/N 946 N2596JMarkshausen Zeke R · Santa Paula, CABuilt 1979 · S/N 18-7909121 N2596PCarlson Eric S · Kodiak, AKBuilt 1978 · S/N 879 N2596WClark Richard · Towanda, PABuilt 1965 · S/N 3283 N2597FDonovan Gerald A · Los Lunas, NMBuilt 1965 · S/N 2 N2597ZSchroeder Herbert D · Plano, TXBuilt 1977 · S/N 1001-77 N2598NRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1984 · S/N 31P-8414050 N2598PLeonard David J · Bettles Field, AKBuilt 1955 · S/N 18-4346 N2598RRiff Raff Air LLC · Isle La Motte, VTBuilt 1969 · S/N 28-5655 N2598WSunset Aviation LLC · New Iberia, LABuilt 1965 · S/N 949 N2599RNeo Aero LLC · Youngstown, OHBuilt 1969 · S/N 28-5656 N2599WBinger Thomas C · Stillwater, MNBuilt 1965 · S/N 950 N2599ZAirborne Images Inc · Encino, CABuilt 1977 · S/N 319-77 N259ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496080 N259CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881004 N259CFMander John E · Kingston, TNBuilt 2003 · S/N BB2059 N259DWSmith Jason · Calliham, TXBuilt 2003 · S/N 3492 N259GFPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280259

Back to AD 87-10-06 R1