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.

N2129AY Naught Aviation LLC · Madill, OKBuilt 1978 · S/N 32R-7987006 N2129GNorth Central Marketing Inc · Cranston, RIBuilt 1978 · S/N 32R-7987080 N2129PRehak Nathan A · Wasilla, AKBuilt 2022 · S/N 211622 N2129TSebesta Arthur J II · Winchester, KYBuilt 1971 · S/N 28R-7135072 N2129UMarzich Frank M · Rockford, ILBuilt 1962 · S/N 177 N2129WDuknic Derek · Magnolia, TXBuilt 1973 · S/N M-1500 N2129ZWelch Peter C · Carmel, NYBuilt 1979 · S/N 28-7911152 N212AAGudger David T · Warwick, MDBuilt 1988 · S/N 212 N212AJDexter James R · Olathe, KSBuilt 1988 · S/N 575 N212ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274432 N212BCRoberts Randall K · Clayton, NMBuilt 1979 · S/N R18201098 N212BGRegistered aircraftBuilt 1980 · S/N 172RG0195 N212BMLeaseair LLC · Wilmington, DES/N 28R-7235136 N212BSEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8243 N212CANichols Larry W · Leavenworth, WAS/N 18-7809133 N212CKSkymates Inc · Grand Prairie, TXBuilt 1979 · S/N 44-7995294 N212FMooney Daniel V · Malvern, PABuilt 1971 · S/N 28-7205015 N212FGWelch Charles E · North Chesterfield, VABuilt 2012 · S/N 40432 N212GPWibel Enterprises Inc · Crossville, TNS/N 24-3327 N212GTGrimm Daniel R · Evansville, INBuilt 1999 · S/N 60248 N212JGArndt Charles H · League City, TXBuilt 1999 · S/N 0738 N212JHHunter James A · Elizabeth City, NCBuilt 1978 · S/N 24-0625 N212JSCridebring Richard L · Caldwell, IDBuilt 2004 · S/N 70146 N212KMMollet Kern · Massillon, OHBuilt 1996 · S/N 4636052 N212LBLysogorski Edward P · Bridgeport, MIS/N 20463 N212LSHeli Ag LLC · Waller, TXBuilt 2006 · S/N 1650 N212MDWashington Donald W · Lafayette, LABuilt 2007 · S/N 72773 N212MSSuper Shine Inc · State Center, IABuilt 1988 · S/N S1304 N212MTLindenauer David L · Boca Raton, FLBuilt 1967 · S/N 670305 N212MWColorado Mountain Leisure LLC · Sioux Falls, SDBuilt 1969 · S/N 690005 N212PDGrossman Steven J · Amherst, NHBuilt 2008 · S/N 1895 N212RGGillum Reef · Clint, TXBuilt 1962 · S/N 24-3123 N212SCarter Christopher L · Franklin, TNBuilt 2008 · S/N 72812 N212SCDavies Charles C · Lovettsville, VABuilt 1967 · S/N 680111 N212SFCrowder Alan L · Madison, GABuilt 1960 · S/N 212 N212STWalsh Scott · Stuart, FLBuilt 1978 · S/N MC-566 N212TMSchuldt Scott A · North Little Rock, ARBuilt 1968 · S/N 17701004 N212TVParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020070 N212WARowland Roger A · Nampa, IDBuilt 2016 · S/N 001 N2130CDurrett Bentley K · Rusk, TXS/N 28-7916132 N2130JEarly Bird Aviation LLC · Rillito, AZBuilt 1978 · S/N 28-7990214 N2130RAscend Aviation LLC · Ira, MIBuilt 1969 · S/N 28-5466 N2130TWasson Ronald L · Colleyville, TXBuilt 1971 · S/N 28R-7135073 N2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MOBuilt 1974 · S/N M-1505 N21313Foster Peter · University Park, TXBuilt 1978 · S/N 32R-7887200 N21318Raw Racing Inc · Puyallup, WABuilt 1978 · S/N 44-7995046 N2131ATru Flight Materials LLC · Wilmington, DEBuilt 2005 · S/N 18281649 N2131ESchuman William C II · Poplar Grove, ILBuilt 1997 · S/N 24-3401 N2131JAllen Harvey · Elfrida, AZBuilt 1978 · S/N 28-7990215 N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111

Back to AD 87-10-06 R1