Registered aircraft · 72,010

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.

N56392Ricottilli Stanley L · Mill Creek, WVBuilt 1973 · S/N 32-7300060 N56393Rotheroe Peter L · 81827 MunchenBuilt 1983 · S/N 24-1377 N56395Pursuit 53 · College Station, TXBuilt 1980 · S/N 7335C N56396Sky North Aviation & Flight Training LLC · Arbuckle, CABuilt 1973 · S/N 287325623 N56398Caprock Spraying Inc · Vega, TXBuilt 1980 · S/N 7340C N5639FTaffet Jay · New Orleans, LABuilt 1976 · S/N 28-7790132 N5639MPayne Maurice A · Bensalem, PABuilt 1983 · S/N 24-1376 N5639PMarchetti Nancy K · Port Charlotte, FLS/N 24-709 N5639UMcconnell Charles L · Phoenix, AZBuilt 1969 · S/N 28-26434 N563APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843764 N563CARegistration Pending · Wilmington, DERegistration pendingBuilt 1975 · S/N 28R-7535275 N563DRural Air Medical LLC · Farmington, UTBuilt 2001 · S/N 2172 N563DEGordon Don · Melba, IDBuilt 2011 · S/N 72326 N563DFGolden Aviation LLC · Hillsborough, NJBuilt 2022 · S/N 2881563 N563FLParkerson James R · Greenville, MSS/N 28-7125405 N563GLBole David M · Auburn, WABuilt 1988 · S/N 7226-E-563 N563JTRick Crum Aircraft Sales Inc · Prestonsburg, KYBuilt 2000 · S/N 3257181 N563KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843936 N563MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020139 N563PJMcdonald Patrick J · Des Moines, IABuilt 1973 · S/N 28R-7335411 N563PRPope County Aviation LLC · Russellville, ARS/N 32-7200027 N563PUAri Ben Aviator Inc · Fort Pierce, FLBuilt 2000 · S/N 2842105 N563SBWalker Linda V · Zeeland, MIBuilt 1973 · S/N 28R-7335429 N563SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881400 N563TDGlenn Jeff P · Billings, MTBuilt 1963 · S/N TD-563 N563UMDelp Gregory E · Woodbury, CTBuilt 1979 · S/N 7254C N563VWRichen Owyn · Seattle, WABuilt 1968 · S/N 32-1029 N563WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 995-2005 N563WWJimenez Daniel L · Goodyear, AZBuilt 2013 · S/N 82390 N56404Mark Lindstrom · Fort Worth, TXBuilt 1973 · S/N 287305586 N56406Blankenship Tyler D · Salisbury, NCBuilt 1980 · S/N 8013C N5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909 N5640NK Top J Cattle Co LLC · Eldorado, TXBuilt 1980 · S/N 8010C N5640QProps To You LLC · Mount Pleasant, SCBuilt 1965 · S/N 676 N5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436 N56410Ehrler Andrew N · Flushing, NYS/N 28R-7335433 N56413Hupert Jason M · Grand Blanc, MIBuilt 1973 · S/N 34-7350329 N56414Gordon David P · Truckee, CABuilt 1973 · S/N 287305588 N56418Shepler John E · Mobile, ALBuilt 1973 · S/N 28R7335434 N5641KAndrews Nathan C · Vale, ORBuilt 1980 · S/N 7338C N5641LSale Reported · Pueblo, COSale reported, canceledBuilt 1980 · S/N 7344C N5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188 N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789 N56424Saunders Equipment Inc · Cold Spring, NYBuilt 1981 · S/N 8017C N56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628 N5642MShower Michael K Jr · Wasilla, AKBuilt 1980 · S/N 7349C N5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049C N56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591 N5643MSandvick Randy R · Killdeer, NDFirst renewal noticeBuilt 1981 · S/N A7358C N5643NVelasquez Bailee Jude · Anchorage, AKBuilt 1981 · S/N A7361C

Back to AD 87-10-06 R1