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.

N514APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843752 N514BDLepkowski Daniel P · Industry, PABuilt 1995 · S/N 5321 N514CMoore Aviation Inc · Beaver Falls, PABuilt 2010 · S/N 2843684 N514CBAnge LLC · Honolulu, HIBuilt 2004 · S/N 3246224 N514CGFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496187 N514CHWehrli Mark A · Missouri Valley, IABuilt 1996 · S/N 0286 N514CMHoward Darrell C · Lafayette, LABuilt 1972 · S/N 32-7240063 N514DMHock Steven R · Indian Hills, COS/N DRM001 N514EEMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881577 N514FVenohr Robert E · Aurora, COBuilt 2009 · S/N 514-2009 N514FLLaurienzo Paul G · Portsmouth, RIBuilt 1971 · S/N 28-7125338 N514HPState Of Ohio / Department Of Public Safety · Columbus, OHBuilt 2005 · S/N 18281651 N514JMCommercial Diving Inc · Melbourne, FLBuilt 1999 · S/N DM5 N514LLLenahan Lawrence M · Scottsdale, AZBuilt 1968 · S/N 680152 N514MCTurbo Aviation LLC · Chesterfield, SCBuilt 2005 · S/N 70776 N514MDPerez Pedro J · Mayaguez, PRBuilt 1975 · S/N 17266476 N514MLPikes Private Planes LLC · Danville, KYBuilt 1968 · S/N 680178 N514MWWalker Michael L · Fredericksburg, TXBuilt 2021 · S/N 25364 N514PHRegistration Pending · Springfield, TNRegistration pending, pending cancellationBuilt 1998 · S/N S1769 N514RBOsprey Holding Company LLC · Foley, ALS/N 17265552 N514RMSobre Las Nubes LLC · Cocoa, FLBuilt 2007 · S/N 2843661 N514TCChildress Anthony H · Frisco, TXBuilt 1973 · S/N 17701995 N514TFFusco Todd S · Durant, IABuilt 2021 · S/N 001 N514WCassill Aircraft Leasing · Cedar Rapids, IAS/N 1-RW N514WJFinke Andy · Lake Geneva, WIBuilt 2016 · S/N 71924 N5150Hlavac Mathew B · Ramona, CABuilt 2005 · S/N MBH-1 N5150DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272435 N5150PPeterson Richard A · Entiat, WABuilt 1958 · S/N 24-166 N5150UMolina Monreal Angel Humberto · Sahuarita, AZS/N 172RG0261 N5150WDunn Scott A · Morris, ILBuilt 1961 · S/N 28-182 N51515Wolfe Douglas S · Yucaipa, CABuilt 1980 · S/N 17274316 N5151PHone Ryan L · West Richland, WABuilt 1958 · S/N 24-167 N5151RLuszczek Christopher L · Berkshire, NYBuilt 1974 · S/N 17263368 N5151XBazer Thomas E · Petersburg, AKBuilt 1969 · S/N 145 N5152QB & L Property Holdings LLC · Brush Prairie, WABuilt 1973 · S/N 17261766 N5152RAero Marine LLC · Denver, NCBuilt 1974 · S/N 17263369 N5152SHarrier Aviation LLC · South Saint Paul, MNBuilt 1970 · S/N 28-7105006 N5152WDavis Gordon · Lexington, KYBuilt 1961 · S/N 28-184 N5153GHeath Sean · Valley Center, CABuilt 2002 · S/N T18208114 N5153LUntil We Fly Away LLC · Orlando, FLBuilt 1967 · S/N 28-4438 N5153PCjl Aviation LLC · Dover, DEBuilt 1958 · S/N 24-169 N5153RVogel Todd J · Bishop, CABuilt 1978 · S/N R18200637 N5153SSierra Flying Club · Buckley, MIBuilt 1970 · S/N 28-7105007 N5153TChampion Phyllis W · Reno, NVBuilt 1966 · S/N 6 N5154DCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17272436 N5154LDunster Edward L · Traverse City, MIBuilt 1967 · S/N 28-4439 N5154MTx Waste Ventures LLC · Caddo Mills, TXBuilt 1978 · S/N M-2037 N5154PPerry Billy C · Newburgh, INBuilt 1958 · S/N 24-170 N5154QDemio Douglas · Westbrook, CTBuilt 1973 · S/N 17261767 N5154RKakkar Sunit · Buena Park, CABuilt 1974 · S/N 17263371

Back to AD 87-10-06 R1