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.

N5088SSwaz Aviation LLC · Mesa, AZBuilt 1971 · S/N 28R-7135089 N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343 N5089GFlywell Aviation LLC · Bowling Green, KYBuilt 1979 · S/N 17273538 N5089JWentzel Ron · Steamboat Springs, COBuilt 1979 · S/N 17273699 N5089RHigh Wing Air Services LLC · Merritt Island, FLBuilt 1974 · S/N 17263327 N5089STye Richard Ray · Silverado, CABuilt 1971 · S/N 28R-7130004 N5089YLewis Aaron J · Salado, TXS/N 27-2109 N508ACKtaz Air LLC · Niceville, FLBuilt 2001 · S/N T18208012 N508AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020007 N508BDIron Wings Aviation LLC · Ralph, MIBuilt 1961 · S/N 28-214 N508CSJoey Os LLC · Darlington, PABuilt 2006 · S/N 11044 N508CXAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2006 · S/N 11074 N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508 N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281 N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869 N508VStahl Victor A · Houston, TXBuilt 2006 · S/N 71303 N508XCHirst Jeremy · Solana Beach, CABuilt 2016 · S/N CC19-0005 N508YLally Michael M · Miami, FLBuilt 1969 · S/N 31-452 N50906Aitken & Wilson Aviation LLC · Leesburg, VABuilt 1980 · S/N 17274232 N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705 N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34 N5090SSturm Neal M · Randolph, NJBuilt 1971 · S/N 28R-7135091 N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346 N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99 N5091717 Leasing LLC · Englewood, COBuilt 1980 · S/N 17274233 N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706 N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100 N5091SLancellotti Peter · Knoxville, TNBuilt 1980 · S/N R18201503 N5091TBlank Philip J · Pleasanton, CABuilt 1981 · S/N R18201814 N5091WRegistration Pending · Anchorage, AKRegistration pendingBuilt 1961 · S/N 28-100 N50924Robinson Mark V · Vacaville, CAS/N 318 N50926Registered aircraftBuilt 1992 · S/N 002 N5092EKaye Russell G · New Fairfield, CTBuilt 1978 · S/N 17271707 N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891 N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347 N50935Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274365 N5093EBohmer Carla M · Tulsa, OKS/N 17271708 N5093KL A M Capital Management LLC · Sheridan, WYBuilt 1980 · S/N 17273964 N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102 N5093RSkyhawks Inc · Montoursville, PABuilt 1974 · S/N 17263331 N5093SPerez Matthew C · Indianapolis, INS/N 28-7125301 N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378 N50941Labrucherie Peter E · El Centro, CAS/N 17264216 N50944Munoz Jacqueline T · Huntsville, ALS/N 17264217 N50947Bend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17264218 N5094RHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N 17263332 N5094SBoraam Aviation Inc · Prospect Heights, ILBuilt 1971 · S/N 28R-7135094 N5094TKrass Roman · West Hills, CAS/N M-1137 N5095RTraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17263333 N5095TColter Duane E · Plainfield, INBuilt 1968 · S/N M-1138

Back to AD 87-10-06 R1