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.

N70987Sutherland Jason · Auburn, WAS/N 18259268 N70988Kelley Ronald C · Deer Lodge, MTBuilt 1968 · S/N 18259448 N7098EHucul Kenneth G · Phoenix, AZBuilt 1960 · S/N 56598 N7098FBumps Stephen D · Gilead, MEBuilt 1966 · S/N 15063698 N7099FMiles Del R · Blackfoot, IDBuilt 1966 · S/N 15063699 N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799 N7099MLake Rodney D · Alturas, CABuilt 1958 · S/N 55399 N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399 N7099TDls Aviation LLC · Missoula, MTBuilt 1959 · S/N 46699 N7099XCornell Donald E · Turner, MTBuilt 1961 · S/N 15059199 N709LCN709lc LLC · Orange, TXBuilt 1966 · S/N 15063937 N709MWGrant Michael R · South Weber, UTBuilt 1968 · S/N 172-56629 N709PTCappe Investment Group LLC · Homestead, FLS/N 17261533 N709RHHope Ronald F · Clemmons, NCBuilt 1970 · S/N 18260387 N70AUQty LLC · Wilmington, DES/N 18503082 N70CWHeartland Travel LLC · Columbia, MOBuilt 1965 · S/N P206-0168 N70DKParmley Terry R · Michigan City, INBuilt 1963 · S/N 17255493 N70DMMl Flight Services LLC · Miami, FLBuilt 1974 · S/N 17263728 N70FFGlassy Water LLC · Portsmouth, NHBuilt 1978 · S/N 18503674 N70GJOzark Airworks Inc · Midway, ARBuilt 1979 · S/N 18267177 N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954 N70KYSurfside Seaplane Training LLC · Lino Lakes, MNBuilt 1953 · S/N 30094 N70RQHarbin Elbert W Jr · Dora, ALBuilt 1974 · S/N 15076276 N70RSStriplin James R Jr · Hartford, ALBuilt 1959 · S/N 46470 N70RTCurtis Robert W · Sikeston, MOBuilt 1962 · S/N 15059628 N70SFreedman Daniel · Santa Ana, CABuilt 1974 · S/N P3370187 N70TASixty Three Charlie Zulu Inc · Thonotosassa, FLBuilt 1979 · S/N 17272891 N70TCTwo Ten Bravo Delta LLC · Kaiser, MOBuilt 1977 · S/N 21061707 N70VHBlue Sky Flyers LLC · Fairfield, NJBuilt 1971 · S/N 18260765 N70WBGraves Lucas M · Santa Rosa, CABuilt 1967 · S/N 18257978 N70WHOrtega Ricky J · Amarillo, TXBuilt 1965 · S/N 18256010 N70WMKeatts Herbert G · Dover, TNFirst renewal noticeBuilt 1980 · S/N R1723361 N71002Sheepdog Aviation LLC · Murfreesboro, TNBuilt 1968 · S/N 18259454 N710061 Lowflyer Inc · Harrisonville, MOBuilt 1968 · S/N 18259455 N71007Farmer Gary E · Saint Augustine, FLBuilt 1968 · S/N 18259456 N71009Fairhurst George D II · Kailua, HIFirst renewal noticeS/N 18259457 N7100ANoel Roberto Vallejo LLC · Orem, UTS/N 29200 N7100GBoyd John J · Wasilla, AKBuilt 1969 · S/N 17258800 N7100MWhiteley Jeffrey L · Jefferson, ORBuilt 1958 · S/N 55400 N7100TDillman Robert F · Suffolk, VABuilt 1959 · S/N 46700 N7100XSale Reported · Lincoln University, PASale reported, canceledBuilt 1961 · S/N 15059200 N71016Fiesbeck Kirt E · Saint Joseph, MIBuilt 1968 · S/N 18259459 N7101AChickasha Wings Inc · Chickasha, OKBuilt 1956 · S/N 29201 N7101GBowhawk LLC · Ocala, FLBuilt 1969 · S/N 17258801 N7101SCuellar Lauren · Eagle River, AKBuilt 1967 · S/N 15067801 N7101TLee Terry R · Little Canada, MNS/N 46701 N7101XKountz Joseph P · Whitehall, MTBuilt 1961 · S/N 15059201 N71028Hawkins Joann L · Cupertino, CABuilt 1968 · S/N 18259462 N7102EWeaver Clifford A · East Berlin, PABuilt 1959 · S/N 52102 N7102GBarbosa Manuel · Apple Valley, MNBuilt 1969 · S/N 17258802

Back to AD 87-20-03 R2