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.

N5349HAviation Advisor Inc · Kenosha, WIBuilt 2003 · S/N T18208198 N5349LHart Brad S · Elephant Butte, NMS/N 28-4652 N5349MWhiskey Bravo LLC · Clarksville, TNBuilt 2002 · S/N 3257307 N5349USilver Ace Aviation · Toccoa, GAS/N 5092 N5349XBegrow Adroaldo Dorivaldo · Gulf Shores, ALBuilt 1986 · S/N 5110 N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754 N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278 N534EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13165 N534FLGray Gary G · Kansas City, MOBuilt 1971 · S/N 28-7125364 N534LU.S. Department Of The Interior · Boise, IDBuilt 2015 · S/N CC18-0075 N534MPJones David C · Williston, VTBuilt 1991 · S/N 10066 N534SASpur Aviation Services Lc · Twin Falls, IDBuilt 1968 · S/N 1816-22 N534WCPrenter Christian E · Hermosa Beach, CABuilt 2002 · S/N 60473 N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769 N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076 N5350LN5350l LLC · Statesville, NCFirst renewal noticeBuilt 1968 · S/N 28-4653 N5350SSilver Tree LLC · Southern Pines, NCS/N R18201551 N5351Robinson Herb · Snowflake, AZBuilt 1997 · S/N 073 N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411 N5351QBarrett Dannie P · Halfway, ORS/N 17261778 N5351TBie Leasing LLC · Hawkinsville, GABuilt 1972 · S/N 32-7240105 N53521Sprague Wolcott E · Westlake Village, CABuilt 2002 · S/N 3257284 N5352BRegistered aircraftBuilt 1958 · S/N 24-406 N5352EEvergreen Aviation & Space Museum & Captian · Mcminnville, ORBuilt 1986 · S/N 5105 N5352KPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 17274077 N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655 N5352WRegistration Pending · Newton, ALRegistration pending, pending cancellationBuilt 1962 · S/N 28-413 N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096 N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078 N5353UTurbo Arrow Aviation LLC · Knoxville, TNBuilt 2002 · S/N 3257275 N5353WYeager Brian · Locust Grove, GABuilt 1962 · S/N 28-416 N53540Orlando Aero Club Inc · Orlando, FLBuilt 1981 · S/N 17274776 N53541Ps N53541 LLC · Green Bay, WIBuilt 1981 · S/N 17274777 N5354DGonzalez Alejandro B · El Paso, TXBuilt 1979 · S/N 17272540 N5354KWassum Kevin Leroy · Apollo Beach, FLBuilt 2005 · S/N 3255033 N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160 N5354SArcturus Bootes LLC · Wilmington, DEBuilt 1980 · S/N R18201552 N5354VHowe Andrew · Wshngtn Xing, PABuilt 2002 · S/N 3257298 N53558University Of Illinois · Savoy, ILBuilt 2002 · S/N 2844083 N5355LSeward Joe T Jr · Fairmount, INBuilt 1968 · S/N 28-4658 N5356DDethlefs Robert L · Clackamas, ORBuilt 1979 · S/N 17272541 N5356FFly By Knight Inc · Hammond, LANon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7715107 N5356LLehuta Steven C · Brunswick, OHBuilt 1968 · S/N 28-4659 N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164 N5356WMahler Alex · Fayetteville, ARBuilt 1962 · S/N 28-420 N5356XSkywest Leasing Inc · St George, UTS/N 2843521 N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528 N53571George Michael F · Ferndale, WABuilt 1981 · S/N 17274781 N53572Arb Aviation LLC · Palm Harbor, FLBuilt 2002 · S/N 3246208 N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537

Back to AD 87-10-06 R1