Registered aircraft · 72,007

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.

N33563Cape Fear Aviation Services LLC · Fayetteville, NCBuilt 1975 · S/N 28-7515346 N33565James Harris · Helotes, TXBuilt 1975 · S/N 28-7505158 N33566Roebke Karen L Trustee · Gilbert, AZBuilt 1975 · S/N 28R-7535161 N33567R Merritt Investments Inc · Jonesville, MIBuilt 1975 · S/N 28R-7535162 N33568Papoi Benjamin F · Phoenix, MDBuilt 1975 · S/N 32-7500025 N3356DShapiro David M · Homer, AKBuilt 1994 · S/N 2461 N3356MH E P Flying Club Corp · Wyoming, MNBuilt 1947 · S/N 12-2184 N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656 N3356WFive Six Whiskey LLC · Plainfield, INBuilt 1965 · S/N 32-200 N33575Nationwide Aviation LLC · Hudson Oaks, TXS/N 28-7515347 N3357KNewman Steve M · Portland, ORS/N 1350 N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657 N3357ZHannon Harland N · Big Lake, AKBuilt 1960 · S/N 22-7297 N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211 N33599A & Aviation LLC · Pinellas Park, FLBuilt 1975 · S/N 28R-7535165 N3359MWarren Wesley L · Coeur D Alene, IDBuilt 1947 · S/N 12-2216 N3359TDuquette Robert R · Elfrida, AZS/N 17700659 N3359WMcmaster James R II · Bath, PABuilt 1965 · S/N 32-205 N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299 N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274 N335BBVantrease David A · Wills Point, TXBuilt 1983 · S/N 24-1367 N335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1389 N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085 N335BWThorp T-18 Ri LLC · Foster, RIFirst renewal noticeBuilt 1995 · S/N 720 N335CBAlcala Miguel Arturo Astorga · Gilbert, AZBuilt 1995 · S/N 3290 N335DPAdvanced Aviation Group LLC · Frederick, MDBuilt 1993 · S/N 2372 N335FDRoy Martin P · Chehalis, WABuilt 1989 · S/N 335 N335HCOtis Stephen H · Mcalester, OKBuilt 2006 · S/N 022 N335MDHamstra Armen Nofer · Saratoga, CABuilt 1982 · S/N 32-8206036 N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466 N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090 N335PABorek Thomas J · Homestead, FLBuilt 1979 · S/N 18-7909158 N335RLWeeks James S · Boynton Beach, FLBuilt 2002 · S/N 23254 N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562 N335RVCroce Matthew A · Palo Alto, CABuilt 2008 · S/N 80335 N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495 N335TBpu Enterprises LLC · Schuylkill Haven, PABuilt 2016 · S/N 2452 N335VHPremier Helicopters LLC · Carson City, NVBuilt 1994 · S/N 2464 N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339 N3360VJustis Jeff · Oxford, MSBuilt 2022 · S/N 42029 N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373 N3361BSmith Marcus H · Roxboro, NCS/N 22-2166 N3361TPew Aaron · Mesa, AZS/N 17700661 N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662 N33631First Class Emergency Vehicles LLC · Monroe, NCBuilt 1975 · S/N 32-7500026 N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213 N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518 N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219 N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349

Back to AD 87-10-06 R1