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.

N28561Carter Boys Aviation LLC · Alma, GABuilt 1979 · S/N 28-7911166 N28565Jenks David R · Hernando, FLBuilt 1977 · S/N AA5B0684 N28569Harper James Barry · Cimarron, NMBuilt 1977 · S/N AA5B0685 N2856AOne Grand Adventure LLC · De Pere, WIBuilt 2007 · S/N 007 N2856DDunn Leslie K · Scottsdale, AZBuilt 2010 · S/N 0022368 N2856HFlight School 101 LLC · Winter Haven, FLS/N 28-7916482 N2856PHester Alan A · Battle Ground, WABuilt 1955 · S/N 22-3156 N2856TGreene Thomas M · Chapel Hill, NCS/N 28-7916483 N2856XHorn Paul M · Vacaville, CAS/N 17700256 N2856ZCooksey Donald R · Newcastle, WYBuilt 1959 · S/N 22-6853 N28572Peck Jeff · Denton, TXS/N AA5B0688 N28573Bearpaw Aviation LLC · Brookfield, WIBuilt 1977 · S/N AA5B0689 N28575Maxwell Jay Nate · Cookeville, TNBuilt 1977 · S/N AA5B0690 N2857MCoastal Air Services LLC · Hampton, SCBuilt 1977 · S/N 32-7840057 N2857PSale Reported · Greeley, COSale reportedBuilt 1979 · S/N 28-7990501 N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857 N2857XWalton Wade · Downingtown, PABuilt 1979 · S/N 28R-7918179 N28583Mcgee Michael R · Mamou, LABuilt 1977 · S/N AA5B0691 N28584Cereal City Flying Club LLC · Battle Creek, MIBuilt 1977 · S/N AA5B0692 N2858HSundt Daniel N Jr Trustee · Bryn Mawr, PABuilt 1979 · S/N 32-7940162 N2858PSiegfried Richard W · Downers Grove, ILBuilt 1955 · S/N 22-3159 N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858 N2858ZRoberts Darren T · Vail, AZBuilt 1959 · S/N 22-6855 N28591Toher Wayne R · Danbury, CTBuilt 1977 · S/N AA5B0696 N28593Mcmillan David S · Rangeley, MEBuilt 1978 · S/N AA5B0697 N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859 N2859TGouda Rafik M · Rancho Cucamonga, CABuilt 1972 · S/N 28-7225254 N285AN285a LLC · Cincinnati, OHBuilt 2000 · S/N 123 N285AAGoldrock Aviation LLC · Princeton, NJBuilt 1974 · S/N 28R-7435156 N285BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842420 N285BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881664 N285CVBarr Air Patrol LLC · Mesquite, TXBuilt 1997 · S/N 18280059 N285DM4 Play Aviation LLC · Port Orange, FLBuilt 1997 · S/N 1236-97 N285DSMonmouth Area Flying Club Inc · Lakewood, NJBuilt 2003 · S/N 40.285 N285EJCounce Mitchell K · Goodyear, AZBuilt 2011 · S/N 91845 N285HCStiller Mark R · Anchorage, AKBuilt 1960 · S/N 18-7464 N285JACarroll Aviation Inc · Carroll, IABuilt 1997 · S/N 2843105 N285JLLink Air Service LLC · Minong, WIS/N T20608373 N285JSFlytruckeetahoe Inc · Truckee, CABuilt 1976 · S/N 17268035 N285MEN285me Holding LLC · Palm City, FLS/N 31-7405410 N285MKPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 2842201 N285PDennin Michael E · Minden, LABuilt 1968 · S/N 28-24804 N285PSShavinsky John E · Fairfield, CTBuilt 1981 · S/N 32R-8229007 N285QAdams Aircraft LLC · Wilmington, DES/N 297 N285TARegistration Pending · Augusta, KSRegistration pendingBuilt 1977 · S/N 28-7716239 N285ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881639 N28604Quest Technical Sales & Marketing Inc · Westlake Village, CABuilt 1978 · S/N AA5B0701 N2860PSchwend Brian · Forsyth, MTBuilt 1955 · S/N 18-4447 N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2860TSchmitz Nicholas S · East Lyme, CTBuilt 1972 · S/N 28-7205232

Back to AD 87-10-06 R1