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.

N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130 N6024DPunt Matthew L · Wasilla, AKBuilt 1956 · S/N 22-4677 N6024NRegistered aircraftS/N 14605 N6024PJohn D Holderman · Sarasota, FLBuilt 1993 · S/N 14608 N6024WWhite Pelican LLC · Union City, TNBuilt 1964 · S/N 28-20024 N60250Camelot Aviation LLC · Wilmington, DEBuilt 1969 · S/N 15070171 N6025LThille Nicholas M · San Luis Obispo, CABuilt 1986 · S/N 5112 N6025WSocal Flights LLC · Simi Valley, CAS/N 28-20025 N6026CPflueger Michael W · Scottsdale, AZBuilt 1978 · S/N R18200357 N6026GAce Pdr LLC · Lewisville, TXS/N 2073 N6026LDolan Kathleen M · Sunnyside, WABuilt 1972 · S/N AA5-0126 N6026QKosmata Charles C · Mcpherson, KSBuilt 1965 · S/N 3234 N6027CShough Mark E · Bemidji, MNBuilt 1978 · S/N R18200358 N6027DSnyder Logan J · Wasilla, AKBuilt 1956 · S/N 22-4680 N6027PJourney Over Destination Aviation LLC · Golden, COBuilt 1959 · S/N 24-1122 N6027QBergh Robert P · Hammett, IDS/N 874 N6028QSky Partners LLC · Sylacauga, ALBuilt 1965 · S/N 875 N6028XHarnagel Duard R · Scottsdale, AZBuilt 1960 · S/N 1618 N6029BSchmidt Glenn J · Wesley Chapel, FLBuilt 1994 · S/N 14613 N6029DRonnie L Tremain · Sherwood, ORBuilt 1956 · S/N 22-4682 N6029QHill John T · Saint Augustine, FLBuilt 1965 · S/N 3235 N6029WWalsh Robert D · Somerset, CABuilt 1964 · S/N 28-20029 N602CBWray David A · Louisville, KYS/N 446-18-1830 N602DDSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609057 N602DTFollow Your Bliss LLC · Woodbury, MNBuilt 1980 · S/N 28-8011118 N602EPJones Theodore R · Prospect, KYBuilt 2002 · S/N 70382 N602FLRoberts David R · West Newton, MABuilt 1971 · S/N 28-7125476 N602FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716056 N602HKing John H · Trumansburg, NYBuilt 1977 · S/N 1077 N602JAAllen John S · Pasadena, CABuilt 2001 · S/N 001 N602JYN13303 LLC · Miami, FLS/N 17262651 N602PCJ & P Aviation LLC · Plymouth, MABuilt 1979 · S/N 28-7990581 N602RVQuick Comfort Inc · Allen, KSBuilt 2001 · S/N 60310 N602SCSale Reported · Marble Falls, TXSale reportedBuilt 2002 · S/N 3257286 N602TPChemic Plane LLC · Grand Rapids, MIBuilt 1981 · S/N 62P09078165035 N602TWChrysalide LLC · Oklahoma City, OKS/N 1 N602WKStrange River Inc · Dripping Springs, TXBuilt 1983 · S/N 60-8365019 N602WTCary Steven B · Brookshire, TXBuilt 2007 · S/N 40336 N602ZRegistration Pending · Mullica Hill, NJRegistration pendingBuilt 1965 · S/N 290 N6030CJames Marvin L · Scio, ORBuilt 1955 · S/N 143-5A N6030DKnipper Larry R · New Lenox, ILBuilt 1956 · S/N 22-4683 N6030FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020093 N6030PAngel Aviation LLC · Paradise, KSBuilt 1959 · S/N 24-1126 N6030QCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1987 · S/N 5121 N6030YReddick Brent · Paragould, ARBuilt 1969 · S/N 27-4370 N6031DCeruto Jorge · Auburndale, FLS/N 22-4684 N6031EHigh Exposure Inc · Wilmington, DEBuilt 1978 · S/N 17271984 N6031FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020094 N6031QWhittier Frank · Las Vegas, NVBuilt 1965 · S/N 876 N6032PStarrynight Bonanza Group LLC · Brighton, COBuilt 1959 · S/N 24-1128

Back to AD 87-10-06 R1