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.

N4243PLandry Lonny R · Fort Worth, TXS/N 23-1742 N4243ZPettit Robert H · Carnegie, OKBuilt 1966 · S/N 18-8471 N4244CBusking Ryan · Houston, TXBuilt 1978 · S/N R18200341 N4244HLeung Henry C · Simsbury, CTBuilt 1978 · S/N 24-0679 N4244LRaser Gary · Birdsboro, PABuilt 2002 · S/N 25079C N4244QCox Danny · Peachtree City, GABuilt 1971 · S/N 17260144 N4244YSalvucci Patsy J · Anchorage, AKBuilt 1998 · S/N 23045C N4245CLogan Gregory A · Chouteau, OKBuilt 1978 · S/N R18200342 N4245HLlewellyn John M · Monroe, WAS/N 14-48 N4245RR J Aviators LLC · Dover, DEBuilt 2001 · S/N 25061C N4245THormazabal Hugo F · Orlando, FLBuilt 1971 · S/N 28-7205115 N4246CDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1978 · S/N R18200343 N4246HAndrews Tyler E · Anchorage, AKBuilt 1948 · S/N 14-49 N4246JBk Media LLC · Hilo, HIBuilt 1967 · S/N 28-22601 N4246QJkg LLC · Murfreesboro, TNBuilt 1971 · S/N 17260146 N42477Holshouser Jeffrey · Riverside, CABuilt 1974 · S/N 28-7415392 N4247HRimensberger Boris D Trustee · Fullerton, CABuilt 1978 · S/N 24-0680 N4247QSchmitt Michael C · Alva, FLS/N 17260147 N4247SBrogden Aviation LLC · Olathe, KSBuilt 1982 · S/N EPC-170 N4247ZJanvrin Jerry M · Buffalo, SDBuilt 1966 · S/N 18-8476 N4248CSchneider Franz E · Bacliff, TXBuilt 1978 · S/N R18200345 N4248HGay Arnash · Harrison, OHBuilt 1978 · S/N 24-0681 N4248JSaia Mark · Oak Harbor, WABuilt 1967 · S/N 28-22604 N4248PDavila Rudolfo G · Runge, TXFirst renewal noticeBuilt 1959 · S/N 23-1747 N4248QPhysics Aviation LLC · Jonesboro, ARBuilt 1971 · S/N 17260148 N4248TCress Terry G · Hollywood, FLBuilt 1971 · S/N 28-7205118 N4249DThorpe Foster B · Saint Augustine, FLBuilt 1999 · S/N 21073C N4249HGapen Patrice M · Cheyenne, WYBuilt 1952 · S/N 14-52 N4249TGulf Bravo Aviation LLC · Lafayette, LABuilt 1971 · S/N 28-7225104 N4249ZBlomquist Frank O · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 18-8478 N424ACGilliam Robert L · Clinton, TNBuilt 1999 · S/N 418-99 N424AKMcgregor Thomas M · Chugiak, AKBuilt 1998 · S/N 1917 N424BHTouchdown Arkansas LLC · Batesville, ARBuilt 1976 · S/N 32R-7780016 N424BWSkye Equipment LLC · Asheboro, NCBuilt 2005 · S/N 80855 N424BYSkyline Soaring Club Inc · Front Royal, VABuilt 1968 · S/N 25-4640 N424FARobinson Todd Allen · San Luis Obispo, CABuilt 2003 · S/N T20608424 N424FLNeihart Randy L · Fontana, CAS/N 28-7125205 N424FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC024 N424GCVandent Aviation LLC · Wilmington, DEBuilt 2023 · S/N 41799 N424KCCoontz James K · Melba, IDBuilt 1964 · S/N 498 N424MROsborne Clarence Michael · Madison, MSBuilt 2019 · S/N 1 N424PAviation Co LLC · Kaneohe, HIBuilt 1974 · S/N 31-7401222 N424PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843468 N424RDTorin Thomas Roschinger · Anchorage, AKS/N 18-5169 N424RHRegistration Pending · Ogdensburg, WIRegistration pendingBuilt 1996 · S/N 2648 N424RMEast End Grill Management Co LLC · Memphis, TNBuilt 1977 · S/N 32R-7780306 N424RNKraut Brian J · Green Cove Springs, FLFirst renewal noticeS/N 480-R N424RWWestphal Jon A · Menomonie, WIBuilt 1989 · S/N 728 N424SBBsi Technologies II Inc · Richmond, VABuilt 1999 · S/N 27-0280 N424SCThread Head Quilting LLC · Anchorage, AKBuilt 1975 · S/N 17702367

Back to AD 87-10-06 R1