Registered aircraft · 22,413

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-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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.

N422GBJacobs Jonathan A · Severna Park, MDBuilt 1999 · S/N 3246143 N422LBMckeever Gregory Allen · Holly Springs, NCFirst renewal noticeBuilt 1981 · S/N 32R-8113030 N422MCWendt Michael · Tecumseh, NEBuilt 1977 · S/N 32-7740088 N422PRicmar Aviation LLC · Lewes, DEBuilt 2007 · S/N 3232065 N422RMMoore Aviation Inc · Beaver Falls, PAS/N 2843526 N422SCAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30022 N422SMCollum Aviation LLC · Milton, FLS/N 28-8116127 N422USParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020125 N422WGWilliams Sara J · Kendallville, INBuilt 1980 · S/N 28-8016341 N4230JPleasant Valley Aviation Inc · Bellefonte, PABuilt 1966 · S/N 28-22579 N4231JBielusiak Stanley J · Dartmouth, MABuilt 1967 · S/N 28-22580 N4231RKearney Larry Neal · Graham, TXBuilt 1969 · S/N 32-40596 N4232FSekel David A · San Diego, CABuilt 1976 · S/N 28-7725005 N4232JN4232j LLC · Waialua, HIS/N 28-22581 N4232TDgap LLC · Niles, OHBuilt 1971 · S/N 28-7210005 N4233R33 Romeo Inc · Wilmington, DEBuilt 1969 · S/N 32-40598 N4234JHomerun Horizons LLC · Weatherford, TXBuilt 1967 · S/N 28-22585 N4234TParsons Donald Jr · Crumpler, NCBuilt 1971 · S/N 28-7205109 N42358Bakker Margaret E Trustee · Petaluma, CABuilt 1974 · S/N 28-7425314 N4235JBarrett Kevin M · Pittsburg, TXBuilt 1967 · S/N 28-22586 N42363Harrison Kent B · Grass Valley, CABuilt 1974 · S/N 28-7415389 N4237JMoppert Stephen Kyler · Madison, MSS/N 28-22589 N4237TPeak 2 Peak Enterprises LLC · Sebring, FLS/N 28-7225101 N4238FAviation Trust Company LLC · Oklahoma City, OKBuilt 1976 · S/N 28-7715010 N4238RMarianas Air Transfer Inc · Saipan, MPBuilt 1969 · S/N 32-40603 N4238TChopper Aviation LLC · Cahokia Heights, ILBuilt 1971 · S/N 28-7205111 N4239ADowden Frank · Fallbrook, CAS/N 32R-7885269 N4239RWilson John T · Castalian Springs, TNBuilt 1969 · S/N 32-40604 N423BMSouth Regional Aviation Enterprise Inc · Boynton Beach, FLS/N 3255022 N423CCAllen Stephen David · Los Banos, CABuilt 1978 · S/N 28R-7803368 N423DMGga N423dm LLC · Glendale, AZBuilt 1969 · S/N 28-25683 N423FLIglewski David W · Muskego, WIBuilt 1971 · S/N 28-7125204 N423JCPeterson Daniel R · Riverview, FLBuilt 1967 · S/N 28-3922 N423JWSkeens Gregory Jr · Encinitas, CAS/N 32-7840163 N423PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843463 N423RElint Technology Inc · Gulf Breeze, FLBuilt 1981 · S/N 32R-8213023 N423RMWrench & Yoke Aviation LLC · Seminole, FLS/N 2843527 N42404Millennium Airways LLC · Valencia, CABuilt 1974 · S/N 28-7415391 N4240JBillings Christopher · St Johns, FLBuilt 1967 · S/N 28-22593 N4240TBlankenbijl Eric J · Grapeview, WAS/N 28-7205112 N4241JImmen David F · Bonanza, ORBuilt 1967 · S/N 28-22594 N4241RFsi Aviation LLC · San Antonio, TXBuilt 1969 · S/N 32-40606 N4243JCase Jamie · Tyngsboro, MABuilt 1967 · S/N 28-22598 N4245THormazabal Hugo F · Orlando, FLBuilt 1971 · S/N 28-7205115 N4246JBk Media LLC · Hilo, HIBuilt 1967 · S/N 28-22601 N42477Holshouser Jeffrey · Riverside, CABuilt 1974 · S/N 28-7415392 N4248JSaia Mark · Oak Harbor, WABuilt 1967 · S/N 28-22604 N4248TCress Terry G · Hollywood, FLBuilt 1971 · S/N 28-7205118 N4249TGulf Bravo Aviation LLC · Lafayette, LABuilt 1971 · S/N 28-7225104 N424BHTouchdown Arkansas LLC · Batesville, ARBuilt 1976 · S/N 32R-7780016

Back to AD 87-08-08 R3