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.

N8277LSillers Kim O · Sault Sainte Marie, MIBuilt 1967 · S/N 17256477 N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277 N8277UEdgewood Farms LLC · Groveland, NYBuilt 1964 · S/N 17252177 N8278EEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1979 · S/N 17272165 N8278FIvey Joseph M · Poland, OHS/N 15064378 N8278UMattison Alan B · Petaluma, CABuilt 1964 · S/N 17252178 N8278XDepew Gerald R · Oak Ridge, TNBuilt 1961 · S/N 17248778 N8279AHadley Harold C · Parma, IDBuilt 1952 · S/N 25131 N8279EHull Farms Inc · Blythe, CABuilt 1979 · S/N 17272166 N8279TGaddis James W · Steelville, MOS/N 17556979 N8279ZVines Forrest Mackenzie · Bonney Lake, WABuilt 1963 · S/N 205-0279 N827DFBrown Edward M · Cabot, ARBuilt 1970 · S/N 15071994 N827DGAfrica Inland Mission International Inc · Peachtree City, GABuilt 1981 · S/N U206-06286 N827LBCapital Consulting LLC · Newport Beach, CABuilt 1979 · S/N R18201006 N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541 N827TWGardner Thomas W · Lincoln, MEBuilt 1973 · S/N 21059836 N827VPClik Services LLC · Forestdale, MABuilt 1959 · S/N 55840 N8280BSea Coast Aviation LLC · Conway, SCBuilt 1957 · S/N 36080 N8280ETrivedi Jay S · Skokie, ILBuilt 1984 · S/N 18268389 N8280TSwift Raptor Aviation LLC · Herndon, VAS/N 17556980 N8280XRegistration Pending · Archer Lodge, NCRegistration pendingBuilt 1961 · S/N 17248780 N8281EAir Plains Services Corp · Wellington, KSBuilt 1979 · S/N 17272168 N8281GWidtfeldt John R · Auburn, PABuilt 1971 · S/N 177RG0181 N8281LSliwinski Kellyn E · Anchorage, AKBuilt 1967 · S/N 17256481 N8281Q9 North LLC · Parker, COBuilt 1976 · S/N U20603142 N8281UHersch Richard E · Arlington, WAS/N 17252181 N8281XStull Carl · Phoenix, AZBuilt 1961 · S/N 17248781 N8281ZSpearfish Aviation Inc · Summerset, SDS/N U20604116 N8282ACole Brian S · Friday Harbor, WABuilt 1952 · S/N 25134 N8282BAmyx Hiram R · Liberty, TXBuilt 1957 · S/N 36082 N8282TLoveless Phillip A · Independence, KSBuilt 1961 · S/N 17556982 N8283LChapin Devon S · Oxford, CTS/N 17256483 N8283UThede Dondi I · Marshall, WIBuilt 1964 · S/N 17252183 N8283XWinfrey Walter A · Auburn, CABuilt 1961 · S/N 17248783 N8283ZClear Prop LLC · Bogalusa, LAS/N 205-0283 N8284LMaxwell Barton W Jr · Crawfordsville, INBuilt 1967 · S/N 17256484 N8285Mason Samuel A · Santa Paula, CABuilt 1982 · S/N 18504393 N8285AReim Sanford E · Fort Myers, FLBuilt 1952 · S/N 25137 N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171 N8285FBearss Gordon M · Lawrence, KSBuilt 1966 · S/N 15064385 N8285UDel Martin Lp · Spring, TXBuilt 1964 · S/N 17252185 N8285XBerntsen Bradley T Trustee · Apple Valley, MNBuilt 1961 · S/N 17248785 N8285ZVaughn Hollis L · Virden, NMBuilt 1963 · S/N 205-0285 N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172 N8286LKyle John M · Wheeling, WVBuilt 1967 · S/N 17256486 N8286M3 Jc LLC · Phoenix, AZBuilt 1970 · S/N 21059286 N8286TWelch Scott P · Lovell, WYFirst renewal noticeBuilt 1961 · S/N 17556986 N8287ALindholm Stanley D Trustee · Lucas, TXBuilt 1952 · S/N 25139 N8287LShirk Matthew · Auburn, INBuilt 1967 · S/N 17256487 N8287MProfessional Metal Services Inc · Albion, NEBuilt 1970 · S/N 21059287

Back to AD 87-20-03 R2