Registered aircraft · 54,017

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.

N5160ELeading Edge Flight Academy LLC · Bend, ORBuilt 1978 · S/N 17271744 N5160RTownley Wren Adam T · Orwell, VTS/N 17263377 N5160TBeaver Enterprises Inc · Wilmington, DEBuilt 1981 · S/N R18201827 N51614Stillwater Flyers LLC · Columbus, MTBuilt 1981 · S/N 17274330 N51616Stardust Aviation LLC · Farmingdale, NYBuilt 1980 · S/N 17274331 N5161ASchmid Robert E · Red Bluff, CABuilt 1955 · S/N 28161 N5161DKnutson Wayne R · Thompson, NDBuilt 1958 · S/N 51261 N5161NLewis Justin R · Frederick, OKBuilt 1980 · S/N 18267552 N5161USkyler Aviation · San Diego, CABuilt 1964 · S/N 206-0161 N5162ASizer Timothy J · Arthur, NES/N 28162 N5162DRodrigues George C · Aiken, SCBuilt 1958 · S/N 51262 N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120 N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379 N5163APassero Robert S · Madison, ALBuilt 1955 · S/N 28163 N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438 N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267 N5163VKopacz Thomas · Glen Flora, WIBuilt 1980 · S/N 172RG0457 N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746 N5164NCaribbean Way Of Life Inc Trustee · Wilmington, DEBuilt 1980 · S/N 18267554 N5165AKulp Robert E Jr · Cartersville, GABuilt 1955 · S/N 28165 N5165BNovember 46a Leasing Inc · St Augustine, FLBuilt 1979 · S/N 15283783 N5165DHull Terri L · Weirsdale, FLBuilt 1958 · S/N 51265 N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382 N5166ADavis Barry E · Carrollton, GABuilt 1955 · S/N 28166 N5166EHanson Michael M · Kent, WABuilt 1959 · S/N 50466 N5166FColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17253052 N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383 N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336 N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747 N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357 N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294 N5168NRidgley Kirk L · Shingle Springs, CABuilt 1980 · S/N 18267555 N5169DHomesick Angel LLC · Black Hawk, COBuilt 1958 · S/N 51269 N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458 N516APStewart Stewart D · South Egremont, MABuilt 1977 · S/N 177-RG-1259 N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205 N516CACharlie Alpha Flying Club · Sunnyvale, CABuilt 1978 · S/N 18266702 N516JWAerostar LLC · Newport Beach, CABuilt 1975 · S/N 17265201 N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889 N51700Brown County Flying Club · Aberdeen, SDBuilt 1980 · S/N 17274338 N5170DSandford Graves M · Moberly, MOBuilt 1958 · S/N 51270 N5170NVx LLC · Melbourne, FLBuilt 1980 · S/N 18267557 N5171AInfinity Metalworks Inc · Newton, KSBuilt 1955 · S/N 28171 N5171DFaber Elgin · Havre, MTBuilt 1958 · S/N 51271 N5171EL & D Air · Foley, ALBuilt 1982 · S/N 18268295 N5171HPan Air Flying Club · Miami, FLBuilt 1975 · S/N 17265358 N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998 N5171RSamuels Jay M · East Tawas, MIBuilt 1974 · S/N 17263388 N5171SHalsted Holdings LLC · Yankton, SDBuilt 1980 · S/N R18201513 N5171USummers Jeffrey L · Pekin, INBuilt 1980 · S/N 172RG0272

Back to AD 87-20-03 R2