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.

N8202AWeaver Savannah N · Fortson, GABuilt 1952 · S/N 25054 N8202F98x LLC · Caddo Mills, TXBuilt 1966 · S/N 15064302 N8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 17256402 N8202SBell Tammy L · San Antonio, TXS/N 15061802 N8202UBudget Flyers · Shreveport, LABuilt 1964 · S/N 17252102 N8202VCebulski Barry A · Fairbanks, AKBuilt 1966 · S/N 18051704 N8202XFerris Tyler S · Pompano Beach, FLFirst renewal noticeS/N 17248702 N8203AVista Aviation Services LLC · Boone, IABuilt 1952 · S/N 25055 N8203GWarne Samuel S · Salisbury, NCBuilt 1971 · S/N 177RG0103 N8203MBottle Meister Inc · San Luis Obispo, CABuilt 1969 · S/N 21059203 N8204GLowe Clinton V · Lake Point, UTBuilt 1971 · S/N 177RG0104 N8204LJohnson Kathy L · Wellsburg, WVBuilt 1967 · S/N 17256404 N8204TChampion Anthony R · Troy, MOBuilt 1960 · S/N 17556904 N8204USchenck Paul · Glendale, CAS/N 17252104 N8204XWallace Howard C · Lompoc, CABuilt 1961 · S/N 17248704 N8204ZLfs Inc · Ekalaka, MTFirst renewal noticeBuilt 1963 · S/N 205-0204 N8205BHarrison Joseph T · Pensacola Beach, FLBuilt 1957 · S/N 36005 N8205FRegistered aircraftBuilt 1966 · S/N 15064305 N8205SMckay Christopher · Point Arena, CAS/N 15061805 N8205UDby Flights LLC · Pennock, MNBuilt 1964 · S/N 17252105 N8205ZMcdaniel George C · Mission Viejo, CABuilt 1963 · S/N 205-0205 N8206AWalker Jack A · Klamath Falls, ORBuilt 1952 · S/N 25058 N8206LPratt Errol C · Fayetteville, GABuilt 1967 · S/N 17256406 N8206MMaxon William D · Santa Paula, CABuilt 1976 · S/N 18264563 N8206UShortridge Gary F · Dover, TNBuilt 1964 · S/N 17252106 N8206VRegistration Pending · Wasilla, AKRegistration pendingBuilt 1966 · S/N 18051708 N8206ZMadson Barry L · Dayton, NVBuilt 1963 · S/N 205-0206 N8207BBodin Logan T · Lake Charles, LAS/N 15069004 N8207FChantry Terrell A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 15064307 N8207GKing Paul · Mount Holly, NJBuilt 1971 · S/N 177RG0107 N8207LAero Biz Development Group LLC · Washington, DCBuilt 1967 · S/N 17256407 N8207MMurphy Robert A · Kent, WABuilt 1976 · S/N 18264564 N8207TColorado Aircraft Maintenance Solutions LLC · Denver, COBuilt 1961 · S/N 17556907 N8208BWidincamp Steve F · Dahlonega, GABuilt 1957 · S/N 36008 N8208EChamplain Island Hoppers · Burlington, VTBuilt 1979 · S/N 17272153 N8208GAerialscapes Inc · Hartland, WIBuilt 1971 · S/N 177RG0108 N8208LMt Avi8or LLC · Sheridan, WYBuilt 1967 · S/N 17256408 N8208VSamalon William S Trustee · Juneau, AKBuilt 1966 · S/N 18051710 N8208XCompass Kitty Hawk LLC · Winneconne, WIBuilt 1961 · S/N 17248708 N8209GJames Billy J II · Comfort, TXBuilt 1971 · S/N 177RG0109 N8209LAbel John R · Haslet, TXBuilt 1967 · S/N 17256409 N8209UWrangell Mountain Air Inc · Palmer, AKBuilt 1961 · S/N 185-0213 N820AHBuffaloe Thomas N · Mancos, COBuilt 1981 · S/N U20606123 N820AKMabry Monte D · Anchorage, AKBuilt 1977 · S/N 18052892 N820CRCeal Company LLC · Long Beach, CABuilt 1977 · S/N 18265561 N820MPPrice Michael Wade · Elkton, VABuilt 1975 · S/N 15076861 N820NR120 Volantes LLC · Cleveland, MSS/N 17250936 N820STTwente Ron K · Saint Peters, MOBuilt 1976 · S/N 15078376 N8210AArdmore Aviation LLC · Novelty, OHBuilt 1952 · S/N 25062 N8210BGibson-Craig-Carmichael Anita Yvonne · Blacksburg, VABuilt 1957 · S/N 36010

Back to AD 87-20-03 R2