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.

N7035AMcgavock Edward A · Columbus, WIBuilt 1956 · S/N 29135 N7035EMetz Kevin Michael · Richmond, UTBuilt 1960 · S/N 56535 N7035QEarly Bird Aviation LLC · Phoenix, AZBuilt 1971 · S/N 17260335 N7036AMachuga James A · Davis, CABuilt 1956 · S/N 29136 N7036UN7036u LLC · West Palm Beach, FLBuilt 1955 · S/N 31621 N70376Sawyer Gregory T · Olga, WABuilt 1976 · S/N 17267206 N70378Vertol Systems Company Inc · Destin, FLBuilt 1976 · S/N 17267207 N7037GN7037g Inc · Newark, DEBuilt 1969 · S/N 17258737 N7037MEissinger Joshua · Circle, MTBuilt 1958 · S/N 55337 N7037QJohnson Joe N · Smithville, TNBuilt 1971 · S/N 17260337 N7037XCloose Brian D · Carlton, MNBuilt 1961 · S/N 15059137 N70380Mindy Ltd LLC · Muscatine, IABuilt 1976 · S/N 17267208 N70386Johnson Ben A · Gainesboro, TNS/N 17267209 N70387Becker Flying Service Inc · Hartington, NEBuilt 1974 · S/N 18801905 N7038EBrainerd Phillip S · Lake Placid, FLBuilt 1960 · S/N 56538 N7038GRoeder Blaine W · El Prado, NMBuilt 1973 · S/N 15074609 N7038QSchenone William M · Mattituck, NYBuilt 1971 · S/N 17260338 N7038TNostdahl Robert W · Bottineau, NDBuilt 1961 · S/N 56331 N7038XBrown Timothy J · Madison, SDBuilt 1960 · S/N 15059138 N70391Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502144 N70392Gateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 17267211 N70394Halford Richard W · Eagle River, AKS/N 18502147 N7039FWharam Glen A · Park River, NDBuilt 1966 · S/N 15063639 N7039GWood Donna L · Wisconsin Dells, WIBuilt 1973 · S/N 15074610 N7039MFurdal Lukasz · Hillsborough, NJBuilt 1958 · S/N 55339 N7039SHotel Sierra LLC · Madison, WIBuilt 1976 · S/N 18265051 N7039XOlson Scott G · New England, NDBuilt 1961 · S/N 15059139 N703AGRegistration Pending · Moorcroft, WYRegistration pendingBuilt 1967 · S/N 337-0727 N703BSOne Grand Adventure LLC · Green Bay, WIS/N R18201930 N703SPFlightline LLC · Lewes, DEBuilt 1985 · S/N 172-76443 N703VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1963 · S/N 17250823 N703ZSibert Gerald R · Tacoma, WABuilt 1971 · S/N 18260582 N70403Mccormick Eugene C DBA · Tyler, ALBuilt 1974 · S/N 18801912T N7040EPegasus Royalty Group LLC · Bozeman, MTBuilt 1960 · S/N 56540 N7040FVtf LLC · Winter Haven, FLBuilt 1966 · S/N 15063640 N7040MHood Shawn D · Weatherford, TXBuilt 1958 · S/N 55340 N7040QOrlandi Properties LLC · Blairstown, NJBuilt 1971 · S/N 17260340 N7040SPro Plus Holdings LLC · Gillette, WYBuilt 1976 · S/N 18265052 N7040TLesko Shannon Lt · Loves Park, ILBuilt 1959 · S/N 46640 N70411Charlie Lima 1 LLC · Jacksonville, FLBuilt 1976 · S/N 17267216 N70413Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1976 · S/N 17267217 N70416Mcgee David · West Monroe, LAS/N 17267218 N7041AOfarrell Scott T · Seattle, WABuilt 1956 · S/N 29141 N7041EDykstra Wayne A · Pipestone, MNS/N 56541 N7041GJohnson Justin Eric · Grand Forks, NDBuilt 1969 · S/N 17258741 N7041QElizabeth City State University · Elizabeth City, NCBuilt 1971 · S/N 17260341 N7041SMaclean John A · Glenview, ILBuilt 1967 · S/N 15067741 N7042AGuilbert Gerald L Jr · Fairfax, VABuilt 1956 · S/N 29142 N7042EBennett Cass · Oxnard, CABuilt 1960 · S/N 56542 N7042FKadlecovic Martin · Prescott, AZS/N 15063642

Back to AD 87-20-03 R2