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.

N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283 N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284 N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N32990Trident Aircraft Leasing LLC · Easton, MDBuilt 1974 · S/N 28-7515285 N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108 N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104 N32998Clark Jeffrey Ryan · Greenville, KYBuilt 1975 · S/N 32-7540079 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N3299WLowe Russell · Navarre, FLS/N 32-133 N329ABDm Aviation Services LLC · Kennebunk, MEBuilt 2004 · S/N 10578 N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000 N329BCHerring Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 2006 · S/N 40190 N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991 N329FPNetwork Spares · Wilmington, DEBuilt 1969 · S/N 18-7421 N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45 N329HPRight Rudder LLC · Halifax, PABuilt 2000 · S/N 3246166 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N329JKEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10674 N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574 N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102 N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461 N329PWalther Cameron R · Hallam, NEBuilt 1977 · S/N AA5A0329 N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512 N329PWHarvey Robert C · Hortonville, WIBuilt 2010 · S/N 40729 N329RPPettis Loren K · Thomaston, GABuilt 2002 · S/N 24828 N329RSTeichman David · Dade City, FLBuilt 1963 · S/N 1303-118 N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512 N329TKaney Jeffrey J · Naples, FLBuilt 1953 · S/N 18-2443 N329TADelta Pacific Northwest LLC · Anchorage, AKBuilt 1968 · S/N 18-8699 N32ABJacobson Neal D · Baker City, ORBuilt 2013 · S/N 81962 N32ADRobinson Helicopter Co · Torrance, CABuilt 1977 · S/N 0002 N32AHLai LLC · Flowood, MSBuilt 1982 · S/N 1268 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32BVH Randal Brennan Pa · Vero Beach, FLBuilt 1972 · S/N 32-7240084 N32BZManganaro John G II · Manvel, TXBuilt 1973 · S/N 32-7300014 N32CGTaylor Group Architects Of California Inc · Fresno, CABuilt 1998 · S/N 27-0245 N32CXSkowbo Rock · Jacksonville, FLBuilt 1976 · S/N 7034C N32CZElk Mountain Rentals Inc · Waynesville, NCBuilt 2003 · S/N 3255011 N32DARalston Mark D · Roseburg, ORBuilt 1977 · S/N 200 N32DHHighgate Aero Inc · Swanton, VTBuilt 2004 · S/N 4542004 N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692 N32EJFox Jason Ross · Buckley, WABuilt 1967 · S/N 28R-30287 N32ERWolfe Bruce · Fredericksburg, TXBuilt 1978 · S/N AA5B0905 N32FDMansfield Stephen K · Boynton Beach, FLS/N 20-1249 N32FNNoska Frank S IV · Wasilla, AKBuilt 2023 · S/N NOSEXP18-001 N32GLG E Air Inc · Broussard, LABuilt 1978 · S/N 3312

Back to AD 87-10-06 R1