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.

N2299BEximious Flying Club Inc · Ferndale, MIBuilt 1977 · S/N 14169 N2299DCheri Lee Inc · Kulpmont, PABuilt 1977 · S/N 14230 N2299PMoeller Wendell L · Porter, TXBuilt 1957 · S/N 23-884 N229AASkyview Aviation LLC · Benton, KYBuilt 1967 · S/N TD-683 N229ABMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881539 N229ALCowboy Pilots LLC · Gilbert, AZBuilt 1988 · S/N 078 N229ANCalifornia In Nice Inc · San Jose, CABuilt 1982 · S/N 17275587 N229APBrown Jeffrey L · San Luis Obispo, CABuilt 1977 · S/N 296/24-08 N229BParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020204 N229BADavila Associates · Dorado, PRBuilt 1975 · S/N 17265585 N229BBKidd Clifford L · Monahans, TXBuilt 1978 · S/N 466-79 N229CHPollux Aviation Ltd · Wasilla, AKBuilt 2004 · S/N 10271 N229DMWisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 28-7890246 N229DRSpecialty Veterinary Services LLC · Monteverde, FLBuilt 1976 · S/N 28R-7635320 N229ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608229 N229ERGood Winds Aero LLC · Roseburg, ORS/N 10125 N229FCOregon Mustang LLC · Brandon, ORBuilt 1972 · S/N M1369 N229FGFlightgest Academy LLC · Morrisville, NCBuilt 2021 · S/N 28020020 N229HPLols LLC · Encino, CABuilt 1990 · S/N CE101 N229JANewman Neal S · Monroe Township, NJBuilt 1974 · S/N 28-7515080 N229JPPallister John S · Battle Ground, WABuilt 1999 · S/N 21092 N229KBBoeing Employees Flying Club St Louis · Saint Charles, MOBuilt 1999 · S/N 001 N229LMMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881572 N229LPDuke Air LLC · Romeo, MIBuilt 2003 · S/N 18281229 N229MKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 27-4252 N229MAN&D Executive Services LLC · San Antonio, TXS/N 4636129 N229METom Wood Aviation Inc · Fishers, INBuilt 2000 · S/N 172S8483 N229MHBwm Holding Group Inc · Greenwich, CTS/N 1441 N229NDAri Ben Aviator Inc · Fort Pierce, FLBuilt 2001 · S/N 2842113 N229NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N 17271323 N229RVElwell Joshua J · West Ossipee, NHBuilt 1995 · S/N 22029-RV6A N229SMamuzich Robert J Jr · Ocala, FLBuilt 1997 · S/N 3-979 N229TBRegistration Pending · Chicago, ILRegistration pendingS/N 1229 N229TYSchilling Aviation LLC · Britton, MIBuilt 1962 · S/N 24-3339 N229VKKuklo Thomas C · Victor, MTBuilt 2021 · S/N 005 N229XSchaich Christopher · Mesa, AZBuilt 2005 · S/N 250 N22AQSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1993 · S/N 2316M N22AZMeyer Damon G · Saco, MEBuilt 1993 · S/N 442 N22BAKovalchuk Richard W · Rosharon, TXBuilt 1976 · S/N AA5A0238 N22BCSky Shark Aviation LLC · Brandon, MSBuilt 1975 · S/N 535-75 N22BMButler Francis J · Fargo, NDBuilt 2003 · S/N 80471 N22BUBruner Charles P Jr · Calabasas, CABuilt 1987 · S/N BRUNER 0001 N22CHSupergo LLC · Menlo Park, CABuilt 1999 · S/N T20608101 N22CJCleveland Adam · Abilene, TXBuilt 1965 · S/N 30-905 N22CKAdams Ventures LLC · Lowell, ARBuilt 1982 · S/N 32R-8213048 N22DDLoegering Daniel P · West Fargo, NDS/N 1650 N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168 N22DQ2 Wings LLC · Noblesville, INS/N DFQ-1 N22DTMartin Communications Inc · West Monroe, LABuilt 1975 · S/N 32-7640033 N22DVSamoilenko Nadia S · Hillsborough, NCS/N 28-1763

Back to AD 87-10-06 R1