Registered aircraft · 54,015

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.

N8116TBliss Kirk R · Maize, KSS/N 17556816 N8116ZJohnston Joshua R · Scappoose, ORS/N 205-0116 N8117AJago River Holdings LLC · Fairbanks, AKBuilt 1952 · S/N 20969 N8117FHhd Aviation LLC · Hamilton, OHS/N 15064217 N8118BBarrera Daniel J · Sugar Land, TXS/N 29918 N8118FMiller Christa L · Rhodesdale, MDBuilt 1966 · S/N 15064218 N8118URegistration Pending · Heath, OHRegistration pendingBuilt 1964 · S/N 17252018 N8119AHuling Lawrence K · Wasilla, AKBuilt 1952 · S/N 20971 N8119TLarson Larry L · Gackle, NDBuilt 1960 · S/N 17556819 N8119URosenoff John D · Riverside, WABuilt 1976 · S/N 15077890 N811BJSix Pack Aviation LLC · Pocono Pines, PABuilt 1979 · S/N 17272287 N811CXRegistration Pending · Brentwood, CARegistration pending, pending cancellationBuilt 1969 · S/N 15070360 N811ECChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1975 · S/N 21060702 N811GMEldredge David A · Snohomish, WABuilt 1979 · S/N 18503770 N811HATate Grady · Harrisburg, NCS/N 17700181 N811JDSanders Jason C · Babylon, NYBuilt 1975 · S/N 17265353 N811LTegtmeier Michael C · Watertown, WIBuilt 1956 · S/N 29014 N811LLLa Vida Aviation LLC · Lake Bluff, ILBuilt 1977 · S/N 18266165 N811XArkoma Aviation LLC · Henryetta, OKBuilt 1966 · S/N T210-0068 N8120AGladden David G · Wasilla, AKBuilt 1952 · S/N 20972 N8120TJordan Francis E · Hillsboro, WIS/N 17556820 N8120UTeague Phillip · Lanett, ALBuilt 1976 · S/N 15077891 N8120ZMechelay Joseph J · Pampa, TXBuilt 1962 · S/N 205-0120 N8121GTwo One Golf Ltd · Waterloo, IABuilt 1971 · S/N 21059421 N8121UFishburn Tol M · Eagle River, AKBuilt 1964 · S/N 17252021 N8121VValley Paul D · Lakeville, MNBuilt 1974 · S/N A1500530 N8122APerkins Christopher R · Brackettville, TXBuilt 1952 · S/N 20974 N8122FGreat Lakes Charity Air LLC · Brown City, MIBuilt 1966 · S/N 15064222 N8122LWoodward Thomas M · Granbury, TXBuilt 1974 · S/N 177RG0610 N8122SAnderson Donald A · Kiel, WIBuilt 1965 · S/N 15061722 N8122XRusty Flyer Aviation LLC · Grove City, OHBuilt 1961 · S/N 17248622 N8123AEgmond Aircraft LLC · Lewes, DEBuilt 1952 · S/N 20975 N8123BVan Maren John C · Owasso, OKBuilt 1957 · S/N 29923 N8123FTilley Christian M · Shelby, MTBuilt 1966 · S/N 15064223 N8123GBlattmachr Matthew · Anchorage, AKS/N U20603770 N8123LShippee Norman J · Foster, RIBuilt 1974 · S/N A1500499 N8123Q8123q LLC · Olympia, WABuilt 1975 · S/N U20603093 N8123TBurns Lawrence S · New Smyrna Beach, FLBuilt 1960 · S/N 17556823 N8123USterner Thomas M · Wilmington, DEBuilt 1976 · S/N 15077892 N8123ZGray Bryan D · Colorado City, TXBuilt 1962 · S/N 205-0123 N8124BVan Skyhawk Charles R · Eagle River, WIS/N 29924 N8124FMurray Mark J · Georgetown, GABuilt 1966 · S/N 15064224 N8124TWanke Michael L · Merrill, WIBuilt 1960 · S/N 17556824 N8124UGardoski Mark · Twin Falls, IDBuilt 1964 · S/N 17252024 N8124VFarhat Jamal M · Rochester, MIBuilt 1977 · S/N R1722316 N8124XNehrbass Douglas · Clarksville, TNBuilt 1961 · S/N 17248624 N8125BTrue Heading LLC · Granite City, ILBuilt 1957 · S/N 29925 N8125MDobson Air Enterprise LLC · College Station, TXBuilt 1976 · S/N 18264543 N8125STucker William F · Booneville, ARS/N 15061725 N8125TLinebaugh Ricky L · Dover, PABuilt 1960 · S/N 17556825

Back to AD 87-20-03 R2