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.

N5035NCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 470-79 N5035QWilfer Dennis M · Fairbanks, AKBuilt 1979 · S/N 292-79 N5035SReady Airways LLC · Roseville, CABuilt 1970 · S/N 28R-35766 N5035WHennells Dann · Naples, FLBuilt 1961 · S/N 28-37 N50361Mcbride Daniel · Burleson, TXBuilt 1979 · S/N 478-79 N5036GVagias Janet Rose · Niceville, FLBuilt 1979 · S/N 473-79 N5036RArctic Winds Inc · King Salmon, AKS/N R18200628 N5036SArrow II Flyers LLC · Jacksonville, FLBuilt 1970 · S/N 28R-35804 N5036WAeroglide Aviation Group LLC · Trenton, NJBuilt 1961 · S/N 28-38 N50371Potter Michael J Jr · Fairbanks, AKBuilt 1978 · S/N 283-78 N50376Hayes Brad M · Grove, OKBuilt 1978 · S/N 282-78 N5037CHakel Bruce A · Fairbanks, AKBuilt 1979 · S/N 1086-79 N5037KD & K Aviation Inc · Milford, IABuilt 1979 · S/N 1087-79 N5037NTriniair LLC · Warner Robins, GABuilt 1979 · S/N 480-79 N5037RJlinn Aviation Inc · Quinlan, TXBuilt 1974 · S/N 17263278 N5037SGannon Gary L · Cumberland, WIS/N 28R-35781 N5037TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250205 N50389Sale Reported · Kissimmee, FLSale reportedBuilt 1979 · S/N 485-79 N5038AWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 376-79 N5038EHohman Brent A · Fulton, SDBuilt 1979 · S/N 481-79 N5038GStarros John P · Los Angeles, CAFirst renewal noticeBuilt 1979 · S/N 377-79 N5038KPiercy Ronald S · Moses Lake, WABuilt 1979 · S/N 482.79 N5038LStopher Patrick K · Anchorage, AKS/N 495 N5038PMidyett Charles O · Cambridge, MDBuilt 1958 · S/N 24-41 N5038SRegistration Pending · Fort Worth, TXRegistration pendingS/N 28R-35806 N5038TBennett Howard N · Georgetown, KYBuilt 1972 · S/N 28-7225326 N5038UButler Industries Inc · Amarillo, TXBuilt 1979 · S/N 484-79 N5038WMarx Karl E · Juneau, AKBuilt 1961 · S/N 28-40 N5038YAileron Buzz LLC · Daytona Beach, FLBuilt 1962 · S/N 27-2044 N50395Registered aircraftBuilt 1979 · S/N 493-79 N50397Wright Preston T · Deeth, NVBuilt 1979 · S/N 1108-79 N5039GPhronesis LLC · Tucson, AZBuilt 1979 · S/N 490-79 N5039HBig Mountain Aviation Inc · Whitefish, MTBuilt 1975 · S/N 17265311 N5039LGreyhawk Aviation LLC · Erie, COBuilt 1979 · S/N 1107-79 N5039NGutman Bradley J · Titusville, FLBuilt 1979 · S/N 492-79 N5039RSmooth Landings Inc · Cary, ILBuilt 1974 · S/N 17263280 N5039TMitchell Robert D · Freehold, NYBuilt 1972 · S/N 28-7225328 N503AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020003 N503AMAlpha Aviation LLC · Spartanburg, SCBuilt 1982 · S/N 17275767 N503CAThompson Paul W Jr · Yachats, ORBuilt 1974 · S/N 17263757 N503DMLau Wolfgang · Cap Canaveral, FLBuilt 1974 · S/N 150-74 N503ETCarnahan Eric Q · Sardinia, OHBuilt 1965 · S/N 28-10598 N503GLWomack Thomas G · Lonoke, ARS/N 0503 N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165 N503JNTailwind Investments LLC · Zeeland, MIBuilt 2000 · S/N 0104 N503LWWechter William P · Ravenel, SCBuilt 2008 · S/N 357 N503MAHobart Aviation Inc · Akron, OHBuilt 1975 · S/N 17266089 N503MZWight Schuyler III · Goldsmith, TXBuilt 1998 · S/N 1405 N503PVMichaels Scott R · Saint Augustine, FLBuilt 2004 · S/N 3FX014 N503RFNovember Tango LLC · Richmond, VABuilt 2005 · S/N 40.493

Back to AD 87-10-06 R1