Registered aircraft · 72,001

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.

N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182 N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094 N2092CElam Nathan A · Hereford, TXBuilt 1978 · S/N 28-7911020 N2092DSelchow Stuart · Plato, MNBuilt 1978 · S/N 28-7911032 N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342 N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872 N20933Meacham Bruce E · Kansas City, KSS/N SA-233 N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874 N2093BTextron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18280041 N2093CJerles William R Jr · Roberta, GABuilt 1978 · S/N 32R-7985022 N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228 N2093SSkyline Aviation Inc · San Angelo, TXS/N S1910 N2093TRollins Wesley F · Clover, SCBuilt 1970 · S/N 28R-7135038 N2093XWord Kyle Remington · Albuquerque, NMBuilt 1979 · S/N 28-7911140 N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876 N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295 N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116 N2094PCampbell John A · Brentwood, TNBuilt 1979 · S/N 32R-7985077 N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459 N2094TSuzuki Yoshinori · Ames, IABuilt 1970 · S/N 28R-7135039 N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879 N20954Hardin John M · Terrell, TXS/N 17263881 N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020 N2095JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608554 N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180 N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683 N2095SMrk Aviation LLC · Delray Beach, FLBuilt 2004 · S/N T20608442 N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077 N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883 N2096ARegistration Pending · Malden, MORegistration pendingBuilt 1978 · S/N 32R-7985001 N2096BN2096b LLC · Buffalo, NYBuilt 1978 · S/N 28-7911008 N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242 N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041 N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257 N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308 N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311 N2098CLynch Stephen J · Stamford, CTBuilt 2004 · S/N T18208228 N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686 N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043 N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N2099CFrazier Jon A · Vista, CAS/N TD-276 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044 N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438 N2099YThompson And Harvey Holdings LLC · Orcutt, CABuilt 2004 · S/N T20608444 N209ARGeery James J · North Fort Myers, FLBuilt 2007 · S/N 71261 N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554 N209BZHipple Patrick · Brecksville, OHS/N SS890830 N209CCCampbell Aviation Inc · Dutton, MTBuilt 1997 · S/N 20209

Back to AD 87-10-06 R1