Registered aircraft · 18,495

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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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.

N777XXAustex Aviation Group Inc · Austin, TXBuilt 2002 · S/N 40058 N777YAerotrack Inc · Hemet, CABuilt 1966 · S/N D-8296 N777YFLandsgaard Equipment Leasing LLC · Wellington, COBuilt 1989 · S/N E-2495 N777YPTim Edwards Co LLC · Wilmington, DEBuilt 2005 · S/N 1299 N777ZDiefenthal Douglas C · Roselle, ILBuilt 1964 · S/N D-7482 N777ZTSee David M · Shady Shores, TXBuilt 1966 · S/N 320E0033 N7781RVoler Exupery LLC · Lewes, DEBuilt 1968 · S/N TE-664 N7786RWinfree Charles E · Edgewood, TXBuilt 1968 · S/N D-8884 N7788HTeodoro Financial Group Inc · Mill Valley, CABuilt 1988 · S/N E-2436 N7789RKing Automobiles Inc · Auburn, ALBuilt 1968 · S/N TE-661 N778CWGarbati Thomas Jr · Waterford, CTBuilt 1981 · S/N U20606184 N778FYQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1148 N778MMTapley Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608012 N778RWSoutherly Winds LLC · Rogers, ARBuilt 1976 · S/N CE-652 N778VKPuerto Rico Management Services Inc · Coral Gables, FLS/N 21062895 N778WSRow Bonanza LLC · Horseshoe Bay, TXBuilt 2019 · S/N E-4130 N7792RHall Mark R · New Smyrna Beach, FLBuilt 1968 · S/N CE-250 N7794RCherokee Aviation LLC · New Smyrna Beach, FLBuilt 1968 · S/N E-126 N7797RTurner Michael C · Suffolk, VABuilt 1968 · S/N D-8890 N7797SBaker Brian · Stanton, TXBuilt 2003 · S/N 0765 N7798NGebhard John M · Hartland, WIBuilt 1977 · S/N U20603718 N7799RRice Kenneth L · Payson, AZBuilt 2011 · S/N L2K-126 N779COweis Yaseen · Bellaire, TXBuilt 2003 · S/N 0444 N779DBAirjohn LLC · Cheyenne, WYBuilt 1985 · S/N TJ-489 N779RBRbi Trading LLC · Morton Grove, ILBuilt 1966 · S/N D-8244 N779WCLane William Michael · Green Bay, WIBuilt 2004 · S/N 1247 N77ABEmap Aviation LLC · Tavernier, FLBuilt 1968 · S/N CJ-12 N77ACEagle Aviation Consulting LLC · Wilmington, DEBuilt 1991 · S/N E-2675 N77BJHint Peter T · Centerport, NYBuilt 1974 · S/N D-9698 N77BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340A-0053 N77BVRegistered aircraftBuilt 1979 · S/N P21000221 N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646 N77CKRaiz Coaching LLC · Fort Worth, TXBuilt 1976 · S/N 20700343 N77CLDopfel Bruce E · Belle Plaine, KSBuilt 1967 · S/N TE-275 N77CRVolatile Aero Ventures LLC · Boulder City, NVBuilt 1976 · S/N U20603458 N77CYN77cy LLC · Lambertville, MIBuilt 1974 · S/N D-9678 N77DADuncan Aviation Inc · Lincoln, NEBuilt 1992 · S/N CE-1649 N77DEHaag Michael E · Granite Bay, CABuilt 1987 · S/N 4608054 N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478 N77ESRegistered aircraftBuilt 1964 · S/N 21058256 N77FAJeff Air Pilot Services LLC · Shelbyville, INBuilt 1974 · S/N 310R0044 N77FELeonard David A · Falmouth, MEBuilt 1972 · S/N 30423 N77FHCumbey Joseph S · Scroggins, TXBuilt 1977 · S/N D-10035 N77GJSees Aviation Inc Trustee · CheltenhamBuilt 2005 · S/N 29-0356 N77GSSouth Carolina Flyers LLC · Aiken, SCBuilt 1981 · S/N P21000613 N77GVBon Vol Ltd · Joliet, ILFirst renewal noticeBuilt 1964 · S/N D-7693 N77HCHlh Properties LLC · Cohutta, GABuilt 1998 · S/N E-3189 N77HTLac Aero LLC · Liberal, KSBuilt 1978 · S/N E-1324 N77JBSilmi Amjad · Fremont, CABuilt 1968 · S/N TE-563 N77JEEngelhardt John L · Netarts, ORBuilt 1977 · S/N E-1080

Back to AD 86-13-04 R3