Registered aircraft · 54,019

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N29224Phelan Ricky Ray · Jefferson, ORBuilt 1968 · S/N U206-1176 N2922AFowler Kenneth Russell · Locust Fork, ALS/N 30122 N2922FKalil Joseph J Jr · Morgan, UTBuilt 1966 · S/N 18257022 N2922JStecklein Brittney R · Overland Park, KSBuilt 1966 · S/N 15065722 N2922SWard Aviation · Marysville, OHBuilt 1967 · S/N 15066822 N29239Gibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264108 N2923AWicklander Richard O · Spanaway, WABuilt 1953 · S/N 30123 N2923DHurd Nathan A · Lisbon Falls, MEBuilt 1955 · S/N 26866 N2923KSallee Daniel C · Port Angeles, WABuilt 1979 · S/N 18053131 N2923SHamann John · Orlando, FLBuilt 1967 · S/N 15066823 N2923UWeber James · Fall Creek, WIBuilt 1963 · S/N 17250523 N2923YS & R Aviation Inc · Boise, IDBuilt 1962 · S/N 18253923 N2924ABennett Ross D · Anchorage, AKBuilt 1953 · S/N 30124 N2924FReese Howard Aviation LLC · Anderson, SCBuilt 1966 · S/N 18257024 N2924JPiscoya Thomas G · Anchorage, AKBuilt 1966 · S/N 15065724 N2924XAllen Thomas L · Cedar Rapids, IABuilt 1967 · S/N 17700324 N2924YLilcad Diversified LLC · Holly Pond, ALBuilt 1962 · S/N 18253924 N29251Southeast Aviation Services Inc · Hattiesburg, MSBuilt 1974 · S/N 17264110 N2925AVan Der Molen Baron J · Readstown, WIBuilt 1953 · S/N 30125 N2925CElla Butte Farming Co · Ione, ORBuilt 1954 · S/N 30825 N2925FRegistered aircraftAssigned, pending cancellationS/N 18257025 N2925SSmolik Amanda · Ponder, TXBuilt 1967 · S/N 15066825 N2925VCortese Thomas J · Sedona, AZBuilt 1977 · S/N R1722234 N2925XPerry Albert D · Houston, TXFirst renewal noticeS/N 17700325 N2925YTrinity Air LLC · Lewes, DES/N 18253925 N2926SFord John M · Rock Stream, NYS/N 15066826 N2926WSessoms Keith V · Seagrove, NCS/N 15284388 N2926YViramontes Gilbert A · Temple City, CABuilt 1962 · S/N 18253926 N29278Pancho Moreno Y La Flaca LLC · Camuy, PRBuilt 1973 · S/N 21059852 N2927ESchafer Thomas Charles · Caledonia, MOBuilt 1978 · S/N 17271374 N2927UCarlson Brent A · Medford, ORBuilt 1963 · S/N 17250527 N2927YReynolds Nathan W Jr · Piedmont, SCBuilt 1962 · S/N 18253927 N29286Wawro Christopher · East Troy, WIBuilt 1974 · S/N 17264114 N29289Disarro Wayne · Wasilla, AKBuilt 1968 · S/N U206-1211 N2928DMatheny Kimberly D · Washington, WVS/N 26871 N2928JVu Huy T · San Diego, CABuilt 1966 · S/N 15065728 N2928SDoubler Endeavors LLC · Orlando, FLBuilt 1967 · S/N 15066828 N2928UHeim Christopher J · Beavercreek, OHBuilt 1963 · S/N 17250528 N2928YDiamond X LLC · Elko, NVBuilt 1962 · S/N 18253928 N29292Skytime Aviation LLC · Tulsa, OKBuilt 1968 · S/N U206-1212 N29299Svetic Russell T · Redondo Beach, CABuilt 1968 · S/N U206-1216 N2929CSinnott Simonis Lyle · Girdwood, AKFirst renewal noticeBuilt 1954 · S/N 30829 N2929FSmith Lane R · Lewistown, MTBuilt 1966 · S/N 18257029 N2929NPekkala Ross F · Palmer, AKS/N 25545 N2929STerrell Aviation Inc · Terrell, TXS/N 15066829 N2929ULarson Michael J · Canton, ILBuilt 1963 · S/N 17250529 N2929XKot Ronald J · Punta Gorda, FLBuilt 1967 · S/N 17700329 N292CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266685 N292CBPelton Project · Keizer, ORBuilt 1975 · S/N 18264306 N292DAIndependence Youth Flying Club Inc · Independence, ORBuilt 1966 · S/N 17255066

Back to AD 87-20-03 R2