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.

N2666GForward Logistics LLC · New Castle, VAFirst renewal noticeBuilt 1959 · S/N 51966 N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866 N2666SHageness Hartley · Rugby, NDBuilt 1968 · S/N 337-0966 N2666URegistration Pending · Decatur, TXRegistration pendingBuilt 1963 · S/N 17250266 N2666VWalden James F · Willcox, AZBuilt 1948 · S/N 18364 N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767 N2667GTundra Aviation Inc · Casselton, NDS/N 51967 N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367 N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347 N2667VPfunke Mark E · Chester, NJBuilt 1948 · S/N 18177 N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768 N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968 N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868 N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368 N2668UMid South Aircraft Inc · Gadsden, ALBuilt 1963 · S/N 17250268 N2668VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 18178 N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769 N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869 N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869 N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369 N2669SWilliams Kent A Jr · Kissimmee, FLBuilt 1968 · S/N 337-0969 N2669VMartin Brian J · Grayslake, ILBuilt 1948 · S/N 18179 N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169 N2669YHession Mark A · Arrington, TNBuilt 1962 · S/N 18051169 N266VFox Stephen A · Wasilla, AKBuilt 1954 · S/N 31215 N2670DBoggess William C · Placerville, CABuilt 1952 · S/N 20822 N2670JMiw Airmen Inc · Marshalltown, IABuilt 1966 · S/N 15065670 N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870 N2670VRetro Air LLC · Seattle, WABuilt 1948 · S/N 18180 N2670YErickson Wesley B · Littleton, COBuilt 1962 · S/N 18051170 N2671JSherman Phillip A · Mansfield, OHBuilt 1966 · S/N 15065671 N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871 N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371 N2671UMetz Thomas H · Mifflintown, PABuilt 1963 · S/N 17250271 N2672FWright James F · Glenford, OHS/N 18256772 N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972 N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729 N2672SJja Transportation LLC · Springville, UTBuilt 1968 · S/N 337-0972 N2672UBender John Lowell Trustee · N Richland Hills, TXBuilt 1963 · S/N 17250272 N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649 N2672YSchmieding Michael · Salem, ORBuilt 1962 · S/N 18051172 N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973 N2673JWest David V · Sandusky, OHBuilt 1966 · S/N 15065673 N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873 N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373 N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348 N2673UBonin Patrick G · Blossvale, NYBuilt 1963 · S/N 17250273 N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650 N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673 N2674DKnefley Michael · Ulysses, PABuilt 1952 · S/N 20826

Back to AD 87-20-03 R2