Registered aircraft · 22,416

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.

N718FLTubesing Gordon E · Palm Coast, FLBuilt 1972 · S/N 28-7225383 N718KTGeorgia Aviation Authority · Eastman, GABuilt 2007 · S/N 2843653 N718NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843852 N718QCCoffee William Mike · Villa Rica, GABuilt 1978 · S/N 32R-7885135 N7190RChristopher Ralph K · Weedsport, NYS/N 28-21903 N7190WAndros Aviation LLC · Santa Margarita, CABuilt 1963 · S/N 28-1002 N7192WPope Larry · Lake View, NYBuilt 1963 · S/N 28-1004 N7194CCivil Air Support LLC · Phoenix, AZBuilt 1975 · S/N 28R-7635096 N7194RAltair Associates · Middletown, DEBuilt 1966 · S/N 28-21908 N7194WWagner Jeffrey P · Bridport, VTBuilt 1963 · S/N 28-1006 N7195WMueller Reinhard B · Sparta, WIBuilt 1963 · S/N 28-993 N7196RCrisler Capital LLC · Sunnyvale, TXS/N 28-21910 N7197RTaylor Timothy T · Quitman, ARS/N 28-21911 N7198RWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1966 · S/N 28-21912 N7199RBrendemuhl Nathan C · Everett, WAS/N 28-21914 N7199WBobkat Aviation LLC · Louisville, KYS/N 281074 N719DFDubroc Marcus C · La Place, LABuilt 1975 · S/N 287510046 N719FLMendoza Fernando · Hialeah, FLS/N 28-7225388 N719MRJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-3412 N719NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843854 N71AKWhittlesy Harold A · Anchorage, AKS/N 28-4386 N71DSSchauer Donald Glen · Minden, NVBuilt 1979 · S/N 28R-7931167 N71DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010071 N71EFSandercock Mark L · Pewaukee, WIBuilt 1972 · S/N 28R-7235176 N71GFUptime Aviation LLC · Fort Lauderdale, FLBuilt 1967 · S/N 283911 N71KKHeadrick Silas · Sparta, TNBuilt 1975 · S/N 32-7500034 N71KTL L C LLC · Rapid City, SDBuilt 1965 · S/N 28-21258 N71LZGriffin Ralph J Jr · Thibodaux, LABuilt 1977 · S/N 28-7816275 N71PMAnderson Aviation LLC · Bulverde, TXBuilt 1971 · S/N 28-7125523 N71PRCti Aircraft Leasing LLC · Memphis, TNS/N 2881302 N71RLPatriot Capital Ventures LLC · Mokena, ILBuilt 2001 · S/N 3246197 N71SATake Off LLC · Boise, IDBuilt 1971 · S/N 28-7125607 N71SHReese Jose A · Yuma, AZBuilt 1967 · S/N 28-4048 N7200JBell Dylan Will Nash · W Columbia, TXBuilt 1968 · S/N 28-24471 N7200WAgri Air LLC · Fairfax, MOBuilt 1963 · S/N 28-1011 N7201FPowell Jonathan C · Philadelphia, PABuilt 1968 · S/N 28-25108 N7201JTrebor Aviation LLC · Prescott Valley, AZBuilt 1968 · S/N 28-24531 N7201WTaylor Robert · Greensboro, NCS/N 28-1012 N7202JAir Indiana LLC · Noblesville, INBuilt 1968 · S/N 28-24533 N7203FLaird Grant M · Puryear, TNBuilt 1968 · S/N 28-25111 N7203JRegistration Pending · Tifton, GARegistration pendingBuilt 1968 · S/N 28-24534 N7204CHousley Communications Inc · San Angelo, TXBuilt 1975 · S/N 32R-7680042 N7204WKlein Kaylin · Stillwater, OKBuilt 1963 · S/N 28-1017 N7206CDwyer Benjamin J · Colorado Springs, COBuilt 1976 · S/N 28-7625072 N7206FVoyage Capital Ventures LLC · Knightdale, NCBuilt 1968 · S/N 28-25114 N7206WSchimmel O L · Port Hueneme, CABuilt 1963 · S/N 28-1020 N7207FLandmark Title Inc · Clovis, NMBuilt 1968 · S/N 28-25115 N7207JErhardt Industries LLC · Ottumwa, IABuilt 1968 · S/N 28-24540 N7207WValkaria Flyers LLC · Palm Bay, FLBuilt 1963 · S/N 28-1021 N7208FWignot Andrew R · Oceanside, CABuilt 1968 · S/N 28-25117

Back to AD 87-08-08 R3