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.

N55641Gizzy LLC · Fish Creek, WIBuilt 1973 · S/N 28R-7335263 N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450 N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434 N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904 N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291 N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266 N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453 N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439 N5565FHenley Brett · Manchester, TNBuilt 1968 · S/N 28-24905 N5565JPerez Luis M Trustee · Corona, CAS/N 32-982 N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629 N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292 N55660Cifuentes Julio · Naples, FLS/N 28R-7335268 N55664Cherokee 55664 LLC · Sparks, NVBuilt 1973 · S/N 28-7310145 N55665Bramley Matt J · Mesa, AZBuilt 1973 · S/N 28-7310123 N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438 N5566PTwig And Giggleberries LLC · Wichita Falls, TXBuilt 1958 · S/N 24-630 N5566UKingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26293 N5566WRegistered aircraftBuilt 1962 · S/N 28-660 N55671Brown Christopher A · Tigard, ORBuilt 1973 · S/N 28-7305440 N55673Smith Gordon H · Racine, WIBuilt 1973 · S/N 28-7305442 N55675Sykes Kinsley · Palm Coast, FLBuilt 1973 · S/N 28-7305443 N55677Arrow II Aviation LLC · Rocky Mount, NCBuilt 1973 · S/N 28R-7335270 N55678Murdick Robert A II · Bluemont, VABuilt 1973 · S/N 28R-7335271 N55679Patriot Parachute Team Inc · Blaine, MNBuilt 1973 · S/N 32-7340132 N5567MAnderson Layne A · Wichita Falls, TXBuilt 1967 · S/N 092 N5567PRegistered aircraftS/N 24-631 N5567QRicol Aviation LLC · Naples, FLBuilt 1965 · S/N 2972 N5567W3k Weavers Investment Group LLC · Shelbyville, KYBuilt 1962 · S/N 28-661 N55680Madsen Pest Management LLC · Siren, WIBuilt 1973 · S/N 28-7325466 N55682Ufer Mark · Sherburn, MNBuilt 1973 · S/N 32-7340108 N55687Rieber Russell C · Stockton, CABuilt 1973 · S/N 28-7305444 N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632 N5568QJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 637 N5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationS/N 28-662 N55691Brown Alan · Lugoff, SCS/N 28-7305447 N55695Straight Arrow Aviation LLC · Aurora, ILBuilt 1973 · S/N 28R-7335273 N55696Walla Walla University · College Place, WABuilt 1973 · S/N 28R-7335274 N55699Hill Caleb · Indianapolis, INBuilt 1973 · S/N 28R-7335281 N5569MWichita Flight Training LLC · Wichita, KSBuilt 1967 · S/N 079 N5569PSpirit Wings Ltd · Wilmington, DEBuilt 1958 · S/N 24-633 N5569QBrian C Elbert · Rochester, NHBuilt 1965 · S/N 2973 N5569UJapikse Bert · Pawleys Island, SCBuilt 1970 · S/N 28-26884 N5569WBridges Michael D · Clovis, NMBuilt 1962 · S/N 28-663 N556BKd Helicopters Inc · Shingleton, MIBuilt 1986 · S/N S1235 N556DBSr Holding And Investment LLC · Wilmington, DEBuilt 2002 · S/N 6053 N556FLKarg Asset Management LLC · Pocahontas, ARS/N 28-7125395 N556GGooch Joel L · Sumter, SCBuilt 2012 · S/N 40931 N556JRSemmig Jeffrey C · Oceanside, CABuilt 1987 · S/N 1144 N556KRWhitaker Robert M · Richfield, UTBuilt 2004 · S/N 90279

Back to AD 87-10-06 R1