Registered aircraft · 22,430

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000 N1003CRogers Justin T · Kalispell, MTS/N 28-22741 N1003QKing Jeffrey J · Fort Worth, TXS/N 32R-7780217 N1004HSmtm Holdings Inc · Wilmington, DEBuilt 1976 · S/N 28-7715301 N1004XRegistration Pending · Yucaipa, CARegistration pendingBuilt 1975 · S/N 28-7525256 N1007LPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-7703403 N1008XSmith Dan V · Anchorage, AKBuilt 1975 · S/N 28-7515373 N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194 N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113 N100LWN100lw LLC · Hickory, NCBuilt 1980 · S/N 32-8006091 N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186 N100NAInternational Air Services Inc Trustee · Carson City, NVS/N 32R-8013093 N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370 N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539 N100WDEveryday Medicine LLC · Nicholasville, KYBuilt 1982 · S/N 32-8224008 N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116 N100WWSwearengin David · Lula, GABuilt 1967 · S/N 28-23611 N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800 N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066 N101DRShaheen Louis · Austin, TXBuilt 1978 · S/N 32R-7885181 N101DWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 32R-7680399 N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172 N101GNGreat Northern Aircraft Inc · Griffith, INBuilt 1976 · S/N 28-7615214 N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920 N101JDresden Leasing LLC · Sheridan, WYBuilt 1965 · S/N 28-20898 N101JKKaras Dean · Lansing, KSS/N 28R-7335243 N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310 N101LLTribeca Aviation LLC · New York, NYBuilt 2000 · S/N 2843367 N101MSKoenig William J · Benedict, MDS/N 28-7125519 N101NL1st American Aviation Inc · North Miami, FLBuilt 1967 · S/N 28-23419 N101NMHarris Group LLC · Springfield, VAS/N 32R7985099 N101RMWarren Isaac J · Tucson, AZBuilt 1965 · S/N 28-21184 N101RTBrodine Alan H · Rochester, NYBuilt 1979 · S/N 28R-8018009 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N101VPN101vp LLC · Ambler, PABuilt 1976 · S/N 28-7790131 N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087 N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381 N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080 N1020DLink Raymond III · Powell, OHBuilt 1974 · S/N 28-7425251 N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219 N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220

Back to AD 87-08-08 R3