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.

N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99 N5091WRegistration Pending · Anchorage, AKRegistration pendingBuilt 1961 · S/N 28-100 N50938J & J Ag Products Inc · Clewiston, FLBuilt 2001 · S/N 3246184 N5093SPerez Matthew C · Indianapolis, INS/N 28-7125301 N5094SBoraam Aviation Inc · Prospect Heights, ILBuilt 1971 · S/N 28R-7135094 N5096TRichards Lyle D · Riley, KSBuilt 1972 · S/N 28-7225344 N5098SBadenhope John R · Greeneville, TNS/N 28R-7135097 N5099TClark Darril W · Scappoose, ORBuilt 1972 · S/N 28-7225347 N509AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020008 N509AMAmerican Asset Leasing LLC · Aurora, ORBuilt 2022 · S/N 2881581 N509DBMaycroft David E · Cary, ILBuilt 1971 · S/N 28R-7135096 N509DXPiper Aircraft Inc · Vero Beach, FLS/N 28010109 N50BTWade William T · Fairhope, ALBuilt 1974 · S/N 28-7415164 N50DJWest Chester Air LLC · West Chester, PABuilt 1981 · S/N 32-8124021 N50HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020135 N50PFMitchell Kenneth A · Uniontown, PABuilt 1984 · S/N 28-8416084 N50PWHandi Corner Inc · Sandersville, GABuilt 1978 · S/N 32R-7885045 N50SELenfestey Thomas J Jr · Wasilla, AKBuilt 1974 · S/N 28-7415514 N50SWR & O Aviation LLC · Hammon, OKBuilt 1980 · S/N 28-8011098 N50WRPaphos Airways LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816642 N50YRBrowning James M · Milaca, MNBuilt 1969 · S/N 28-25467 N5100LWilder Carl T · Budd Lake, NJBuilt 1967 · S/N 28-4372 N5100SParks Victor Lee · Houston, TXBuilt 1971 · S/N 28-7125318 N5100THaynes Michael H · Anniston, ALBuilt 1972 · S/N 28R-7235191 N5101GWash Stephen · Franklin, TNBuilt 1967 · S/N 28-3969 N5101SWaddill John W · Houston, TXBuilt 1971 · S/N 28R-7135103 N5102GHeussler Ryan · Rio Dell, CABuilt 1967 · S/N 28-4003 N5102SK & N Aviation LLC · Rock Hill, SCBuilt 1971 · S/N 28-7105125 N5103GMcfarland Les · Bourbon, INBuilt 1967 · S/N 28-4004 N5104LLamer Roland W · Fresno, CABuilt 1967 · S/N 28-4374 N5105SSyphers Harold A · Aguila, AZBuilt 1971 · S/N 28-7125335 N5106LArnold John D · Reno, NVBuilt 1967 · S/N 28-4376 N5107LSmith Jeremy · Houston, TXBuilt 1967 · S/N 28-4389 N5107SJdc Aviation LLC · Upland, CABuilt 1971 · S/N 28R-7135108 N5107TIron Horse Leasing LLC · Platteville, WIS/N 28R-7235192 N5109GSnamiska Kyle · Cypress, TXBuilt 1967 · S/N 28-23174 N5109SBucek James A · Baytown, TXBuilt 1971 · S/N 28-7105129 N510BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881852 N510DROriley Rickalan H · Encino, CABuilt 1978 · S/N 28R-7803304 N510DXPiper Aircraft Inc · Vero Beach, FLS/N 28010110 N510FHCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841179 N510TEPluid Darwin D · Eureka, MTBuilt 1977 · S/N 28R-7803124 N510THRegistration Pending · Oxford, CTRegistration pendingBuilt 1975 · S/N 28R-7535221 N5110GN5110g LLC · Orlando, FLS/N 28-23211 N5110YCarpe Diem Aviation LLC · Cleveland Heights, OHBuilt 2000 · S/N 2843407 N5111SC And A Aviation Inc · Baltimore, MDBuilt 1971 · S/N 28-7105130 N5112LRyan Lowe Aviation · Costa Mesa, CABuilt 1967 · S/N 28-4394 N5113LTessos Air Service Inc · Wilmington, DEBuilt 1968 · S/N 28-5083 N5114LHenry Lawrence D · Lohman, MOBuilt 1967 · S/N 28-4397 N5114SConner W Larry · Los Lunas, NMBuilt 1971 · S/N 28R-7135148

Back to AD 87-08-08 R3