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.

N24139Averett University · Danville, VABuilt 2011 · S/N 2843697 N2413TRing Michael E · Lake Village, INBuilt 1971 · S/N 28-7205053 N2414PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4289 N24153Mt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17275094 N24155American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275290 N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290 N2416MSun South Aviation LLC · Wilmington, DEBuilt 1977 · S/N 32R-7880063 N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781 N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274 N2417KDarley Vernon O · Peachtree City, GABuilt 2024 · S/N HC 0186 N2417MRens Troy D · Marshfield, WIBuilt 1977 · S/N 32R-7880064 N2417PMehling Craig · Hardin, MTS/N 18-4293 N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617 N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81 N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091 N2419RLynch Gerald A · Santa Barbara, CABuilt 2000 · S/N 18280927 N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182 N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039 N241AWStewart Lawrence D · Council Bluffs, IABuilt 2004 · S/N 5614 N241BHughes Dustin G · Texarkana, TXBuilt 2016 · S/N 571702 N241BDHanus David S · Mound, MNS/N 60477 N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160 N241DKSale Reported · Wilmington, DESale reportedBuilt 2022 · S/N 367 N241DWGaither William W Jr · Shallotte, NCS/N 634RG N241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889 N241GSmith Albert K · Pentwater, MIBuilt 1978 · S/N 14394 N241GTBroshchan Ruslan A · Jackson, MSS/N 2141 N241GWWheeler Gregory R · Spicewood, TXS/N 2248 N241HCButcher Robert E · Friendswood, TXBuilt 2005 · S/N 81966 N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011 N241JESmedshammer Paul J · Petaluma, CABuilt 2001 · S/N 23868 N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241 N241KCChase Kenneth W · Anvik, AKS/N 22-4138 N241KDReiter Kenneth L · Plano, TXBuilt 1998 · S/N 162 N241KRMako Offshore Exploration Inc · Pagosa Springs, COBuilt 2004 · S/N T18208326 N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602 N241LWDrouin William · Brookline, NHBuilt 1970 · S/N 700088 N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761 N241MJMj Aero LLC · Mims, FLBuilt 1987 · S/N 1055 N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051 N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214 N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589 N241PCPlucinski David J · San Clemente, CABuilt 2005 · S/N 1385-2005 N241PLAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276422 N241RAGreat Escape Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 1322-2001 N241RBJankowski Richard S · Shenandoah, TXBuilt 1997 · S/N 23274 N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916 N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110 N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113 N241TWScotton Bradley D · Galena, AKBuilt 1996 · S/N TW96-002

Back to AD 87-10-06 R1