Skip to content

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.

N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N3011KBravo Farm LLC · Dover, DEBuilt 1978 · S/N 32-7940023 N3011NLange Jonathan R · La Mesa, CAS/N 28-7911098 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011XHanania-Stout Motorcars LLC · Chattanooga, TNBuilt 1979 · S/N 32-7940093 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N30128Mizani Air LLC · San Antonio, TXBuilt 1968 · S/N 17701069 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012BThrowbacks LLC · Pueblo, COBuilt 1978 · S/N 28-7911016 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402 N3012LCwp Flight LLC · Lawton, OKBuilt 1979 · S/N 32-7940031 N3012NBirkenseer James J · Danville, CAS/N 28-7911099 N3012ZChase 13 LLC · Wilmington, DEBuilt 1959 · S/N 22-6963 N30133Ts Fliers LLC · Mount Pleasant, MIBuilt 1968 · S/N 17701070 N30139Heinitz Bradford C · Arlington, WAS/N 17701074 N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170 N3013NAnderson John · Hollister, CABuilt 1979 · S/N 28-7911100 N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395 N3014B-Line Air LLC · Malcom, IABuilt 2008 · S/N 1961 N30142Marshman Robert M · Murfreesboro, TNBuilt 1968 · S/N 17701075 N30144Roberti Aviation Of Delaware Inc · Lighthouse Point, FLS/N 3257330 N30145Keno Aviation LLC · Marshfield, MAS/N 17701077 N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085 N30148Tyler Marion B · Lacey, WABuilt 1968 · S/N 17701079 N3014GWings Aircraft LLC · Anacortes, WABuilt 1978 · S/N 28-7911072 N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182 N3014MBaum James L Trustee · Anchorage, AKBuilt 1947 · S/N 12-1572 N3014XReasoner Michael L · Corvallis, ORBuilt 1979 · S/N 32-7940094 N30151Miller Jacob G · Harrison, ARFirst renewal noticeS/N 17701081 N30153Waters Donovan D · Peoria, AZBuilt 1968 · S/N 17701082 N30157Cardinal Aviation LLC · Pelham, NHBuilt 1968 · S/N 17701086 N30158Segroves Jeffrey S · Milledgeville, GABuilt 1968 · S/N 17701087 N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171 N3015ECuevas Ernesto · Orlando, FLBuilt 1978 · S/N 17271404 N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335 N3015ZPittman Leo B · Stanfield, AZBuilt 1959 · S/N 22-6966 N30166De Jager Henry · Smithville Flats, NYBuilt 1968 · S/N 17701093 N3016DHuybrechts Dirk J · Los Angeles, CAFirst renewal noticeBuilt 1978 · S/N 28-7911040 N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284 N3016NParker James C · Rescue, CABuilt 1979 · S/N 32-7940038 N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298 N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086 N30173Tolman William C · Maryville, TNBuilt 1978 · S/N 32R-7887270 N30179Kowatra Anil K · Lilburn, GABuilt 1968 · S/N 17701103 N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184 N3017PDragonfly Aviation LLC · Mirando City, TXBuilt 2007 · S/N 1820 N30182Johnson Arnold R · Mina, SDBuilt 1968 · S/N 17701105

Back to AD 87-10-06 R1