OpenAirDocs.org
AD 87-20-03 R2

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
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.

N68813Vogt Jeffrey D · Pleasant Grove, CAS/N 15282388N68814Spooner Wade G · Donalsonville, GABuilt 1978 · S/N 15282389N68815Skippy Aviation LLC · Bridgeport, PAS/N 15282390N68816Mirkovic Alex · Friendswood, TXBuilt 1978 · S/N 15282391N6881EInternational Air Services Inc Trustee · Carson City, NVS/N 56381N6881XWestmoreland Dennis F · Snyder, TXBuilt 1960 · S/N 17247781N6882FHernandez Kevin F · Redmond, ORBuilt 1966 · S/N 15063482N6883AOswego Joint Venture · Tchula, MSBuilt 1956 · S/N 28983N6883GSchroeder David C · Norfolk, NEBuilt 1970 · S/N 15072383N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625N6884XBaked Industries Inc · Yuba City, CAFirst renewal noticeBuilt 1960 · S/N 21057664N6885EHeiser Reggie · Polson, MTBuilt 1959 · S/N 56385N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626N6886EHadley David C · Herriman, UTBuilt 1959 · S/N 56386N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627N6886MJohnson Bill J · Canton, GABuilt 1975 · S/N 18263879N6887ABradshaw Gary E · Warfordsburg, PABuilt 1956 · S/N 28987N6887EPatton Martin O · North Ridgeville, OHS/N 56387N6887GMassuet Nancy O · Sunrise, FLBuilt 1970 · S/N 15072387N6888ESteinhausen Darrell · Torrington, WYBuilt 1959 · S/N 56388N6888HN6888h LLC · Wayne, NJS/N 17265628N6889DBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7846N6889GKozlowski James · Zeeland, MIBuilt 1970 · S/N 15072389N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289N6889XSchler Joseph B · Reno, NVBuilt 1960 · S/N 17247789N688CABetter Southlake Properties LLC · Pagosa Springs, COS/N 17262505N688CMIcan Solutions LLC · Fargo, NDS/N 15282421N688DDPropit Inc · Wilmington, DES/N 17251057N688JFCrothers Travis · Madison, MSBuilt 1968 · S/N 18259510N688KTGlore Reilly P · Olympia, WABuilt 1972 · S/N 18261187N688PAJoe P Fassio · Union, WABuilt 1953 · S/N 25535N688WBaum Eldon L Jr · Wellsville, PABuilt 1956 · S/N 28695N6891EOakes Stephen · Joshua Tree, CAS/N 56391N6891FN6891f LLC · Woodruff, SCBuilt 1966 · S/N 15063491N6891HRegistration Pending · Uvalde, TXRegistration pendingBuilt 1975 · S/N 17265630N68920Richmor Aviation Inc · Hudson, NYBuilt 1978 · S/N 15282403N68926Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282405N6892FDent Kelly J · Locust Grove, GABuilt 1966 · S/N 15063492N6892GDetroit Public Schools Community District · Detroit, MIS/N 15072392N68934Bapes Debra L · Powell, OHS/N 15285341N68938Wingspan 152 LLC · Valparaiso, INBuilt 1978 · S/N 15282408N6893AFarris Lyle E · Faucett, MOBuilt 1956 · S/N 28993N6893EArmstrong Bruce · Port Orchard, WABuilt 1960 · S/N 56393N6893GHuesgen Paul M · Villa Ridge, MOBuilt 1970 · S/N 15072393N6894ASw Aero Training LLC · Rio Rancho, NMBuilt 1956 · S/N 28994N6894FSudduth Robert J · Huachuca City, AZBuilt 1966 · S/N 15063494N68954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282414N68956Spartan Education LLC · Tulsa, OKFirst renewal noticeBuilt 1978 · S/N 15282415N6895ADettman Gary L · Spearfish, SDBuilt 1956 · S/N 28995N6895ETharp Marc B · Mulberry, FLS/N 56395
Back to AD 87-20-03 R2