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.

N4238CSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N EPC-155 N4238FAviation Trust Company LLC · Oklahoma City, OKBuilt 1976 · S/N 28-7715010 N4238QFisch Markus J · Rock Falls, ILBuilt 1971 · S/N 17260138 N4238RMarianas Air Transfer Inc · Saipan, MPBuilt 1969 · S/N 32-40603 N4238TChopper Aviation LLC · Cahokia Heights, ILBuilt 1971 · S/N 28-7205111 N42396Lawrence Jack C Jr · Saint Augustine, FLBuilt 1990 · S/N EPC-161 N4239ADowden Frank · Fallbrook, CAS/N 32R-7885269 N4239HGray Steven Don · Tualatin, ORBuilt 1978 · S/N 24-0678 N4239POneal Hollis R · Deridder, LABuilt 1959 · S/N 23-1737 N4239QElizabeth City State University · Elizabeth City, NCS/N 17260139 N4239RWilson John T · Castalian Springs, TNBuilt 1969 · S/N 32-40604 N4239WSmith James W · Newtown, CTS/N 21079C N4239ZLsk Aviation Corp · Wilmington, DEBuilt 1966 · S/N 18-8466 N423ATWillcutt Air Tax LLC · Vicksburg, MIBuilt 1978 · S/N 14391 N423BMSouth Regional Aviation Enterprise Inc · Boynton Beach, FLS/N 3255022 N423CFMiller Lyndon J · Georgetown, TXBuilt 2008 · S/N 001 N423CMHurricane Creek Flying Club LLC · Walla Walla, WABuilt 2000 · S/N 20608109 N423CZRutan Aircraft Flying Experience · Waller, TXS/N 423 N423DKOliveira Avelino Da Mota · Aventura, FLBuilt 1981 · S/N R18201809 N423DMGga N423dm LLC · Glendale, AZBuilt 1969 · S/N 28-25683 N423FLIglewski David W · Muskego, WIBuilt 1971 · S/N 28-7125204 N423FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC023 N423JAGiegler Bernard · Cypress, TXBuilt 2002 · S/N 60241 N423JCPeterson Daniel R · Riverview, FLBuilt 1967 · S/N 28-3922 N423JDAlbert Hall Co LLC · Shreveport, LABuilt 2004 · S/N 1179 N423JTSoutheast Air Tran LLC · Hahira, GABuilt 1994 · S/N 4622162 N423JWSkeens Gregory Jr · Encinitas, CAS/N 32-7840163 N423LCYabsley Richard A · Santa Barbara, CABuilt 2017 · S/N 517R N423PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843463 N423PSTabano Anthony · National Harbor, MDBuilt 2004 · S/N 27-0326 N423PWBeggs Pat · Salem, ORBuilt 2018 · S/N CC19-0039 N423RElint Technology Inc · Gulf Breeze, FLBuilt 1981 · S/N 32R-8213023 N423RVIndy Air Sales LLC · Anderson, INBuilt 1991 · S/N 1023 N423SPSierra Papa LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8352 N423TSandpoint Aviation LLC · Sandpoint, IDBuilt 2003 · S/N 43 N423TABas Part Sales LLC · Greeley, COBuilt 2003 · S/N T18208208 N42404Millennium Airways LLC · Valencia, CABuilt 1974 · S/N 28-7415391 N4240HSorensen Michael J · Mayer, MNBuilt 1948 · S/N 14-42 N4240JBillings Christopher · St Johns, FLBuilt 1967 · S/N 28-22593 N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140 N4240TBlankenbijl Eric J · Grapeview, WAS/N 28-7205112 N4240XMaule Group LLC · Danbury, CTBuilt 1999 · S/N 30004C N4240ZLoomer Orville C · Buffalo, WYS/N 18-8467 N42415Barron Texas Holdings LLC · Sheridan, WYS/N EPC-162 N4241JImmen David F · Bonanza, ORBuilt 1967 · S/N 28-22594 N4241RFsi Aviation LLC · San Antonio, TXBuilt 1969 · S/N 32-40606 N4242GMaritz Paul A · Mercer Island, WABuilt 2000 · S/N 867-2000 N4242QRegistered aircraftS/N 17260142 N4242ZWing Robert E · Fairbanks, AKBuilt 1967 · S/N 18-8597 N4243JCase Jamie · Tyngsboro, MABuilt 1967 · S/N 28-22598

Back to AD 87-10-06 R1