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.

N5171VLisenbey Edward · Caldwell, IDS/N 21060846 N5172ABarnes Timothy Edward · Stephenville, TXBuilt 1955 · S/N 28172 N5172HMsi Fuel Management Inc · Vacaville, CABuilt 1975 · S/N 17265359 N5172RWaterhouse Roy Todd · Mccall, IDBuilt 1976 · S/N 18503012 N5173ERyznar Daniel J · Anchorage, AKBuilt 1959 · S/N 50473 N5173UKnutson Wayne R · Tioga, NDBuilt 1964 · S/N 206-0173 N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342 N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174 N5174BSky Associates Inc · Jupiter, FLBuilt 1979 · S/N 15283790 N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752 N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360 N5175ADenkema Richard S · Grand Rapids, MIBuilt 1955 · S/N 28175 N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753 N5175NArkansas Bolt Co · Little Rock, ARBuilt 1980 · S/N 18267560 N5176EAirplane Money Pit LLC · Rexburg, IDBuilt 1982 · S/N 18268296 N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044 N5176VVangorder Donna · Greenwood, ARS/N 172RG0459 N5177AHolden Daniel N · Anacortes, WAS/N 28177 N5177DCross Richard G · Brewster, MNBuilt 1958 · S/N 51277 N5177EAbraham Edward C · Canadian, TXBuilt 1959 · S/N 50477 N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361 N5177NMacelvaine William Stephen · Morro Bay, CABuilt 1980 · S/N 18267561 N5178EHughes Kenneth L Jr · Wasilla, AKBuilt 1959 · S/N 50478 N5178FTurrentine Danny H · Wolfe City, TXBuilt 1965 · S/N 17253100 N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395 N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347 N51794Christiansen Aviation LLC · Wilmington, DES/N 17274348 N5179DBlack Daniel L · Spicewood, TXBuilt 1958 · S/N 51279 N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362 N5179UPower Flight LLC · Las Vegas, NVBuilt 1964 · S/N 206-0179 N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460 N517CAFisher Richard L Jr · Saint Helens, ORS/N 17268100 N517DBBerry Bruce E · Louisville, TNBuilt 1977 · S/N 18266021 N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965 N517MSJewett John G · Ellensburg, WABuilt 1978 · S/N R18200681 N517PCAfrican Bible Colleges Inc · Karval, COBuilt 1973 · S/N 18261628 N517RANason David F · Kent, WABuilt 1961 · S/N 15059375 N517SAHalo For Freedom Warrior Foundation · Willow Park, TXBuilt 1966 · S/N U206-0644 N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318 N517TGMcdonald Richard Reid · Rock Island, WAS/N 18517 N5180Allen Michael G H · Casper, WYBuilt 1961 · S/N 18051077 N5180AWarmack Holdings LLC · Englewood, FLBuilt 1956 · S/N 28180 N5180EMission Aviation Training Academy · Arlington, WABuilt 1959 · S/N 50480 N5180FUnited States Air Force Owner · Hanscom Afb, MABuilt 1965 · S/N 17253108 N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397 N5180UAssociation Of Baptists For World Evangelism Inc · Harrisburg, PABuilt 1964 · S/N 206-0180 N5181DSchrick Robert B · Firth, NEBuilt 1958 · S/N 51281 N5181HRegistered aircraftBuilt 1975 · S/N 17265363 N5181NValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 18267562 N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398

Back to AD 87-20-03 R2