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.

N2648VWhite Jeffrey W · Macon, GABuilt 1974 · S/N 177RG0642 N2648YSw Aviation Services Inc · Queen Creek, AZBuilt 1955 · S/N 31676 N2649FSkylane 2649f LLC · Kalispell, MTBuilt 1965 · S/N 18256749 N2649GSwanson Gregory N · Meridian, IDS/N 51949 N2649RShah Aitazaz · Shady Shores, TXBuilt 1967 · S/N 18258349 N2649UMorrison Kent · Mccleary, WAFirst renewal noticeBuilt 1963 · S/N 17250249 N2649VStedingh Donald M · Anchorage, AKBuilt 1948 · S/N 18159 N2649XK-Mcj Equipment LLC · Longview, TXS/N P206-0149 N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035 N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716 N264MSanterre Phillip E Trustee · Chugiak, AKBuilt 1958 · S/N 50236 N265E&S Management LLC · Miami, FLBuilt 1975 · S/N P3370232 N2650DBrekke Aviation Inc · Edmore, NDBuilt 1952 · S/N 20802 N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750 N2650GNewkirk Kevin J · Manhattan, KSS/N 51950 N2650JNoll Cheryl A · Franklin, NCBuilt 1966 · S/N 15065650 N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850 N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751 N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851 N2651VHagl Aviation LLC · Sunray, TXBuilt 1976 · S/N R1722226 N2652DScheidler Jerome P · Greensburg, INBuilt 1952 · S/N 20804 N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752 N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852 N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352 N2652VTrapp Terry Lee Trustee · The Dalles, ORBuilt 1974 · S/N 177RG0644 N2653Barr Air Patrol LLC · Mesquite, TXBuilt 1982 · S/N 18268297 N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753 N2653GDevine Christopher C · Eagle River, AKBuilt 1959 · S/N 51953 N2653QMoses And Associates Inc · Gainesville, FLBuilt 1966 · S/N 18257853 N2653UClark Nikita C · Ontario, ORS/N 17250253 N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754 N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854 N2654RFindarle John J · Midway, UTBuilt 1967 · S/N 18258354 N2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationBuilt 1974 · S/N 177RG0645 N2654YHolty Joseph G · Fairbanks, AKBuilt 1962 · S/N 18051154 N2655DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 20807 N2655GBeachy Benjamin D · Whittington, ILBuilt 1959 · S/N 51955 N2655NLetourneau David W · Valencia, CABuilt 1976 · S/N 15077878 N2655QRedmond Angela L · Austin, TXBuilt 1966 · S/N 18257855 N2655RBeck Bartholomew · Dry Ridge, KYBuilt 1967 · S/N 18258355 N2655ZRegistered aircraftN-number assigned (import), not yet registeredS/N 185-0655 N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196 N2656JSperling Gabriel E · Silverdale, WABuilt 1966 · S/N 15065656 N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029 N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856 N2656QPankrate Kenneth W · Opheim, MTS/N 18257856 N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2656VMccurdy James Rodney · Statesville, NCS/N 18166 N2657DBouvrie Lukas J · Boulder, COBuilt 1952 · S/N 20809

Back to AD 87-20-03 R2