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.

N2400YClark Nikita C · Ontario, ORFirst renewal noticeBuilt 1962 · S/N 17249700 N24012Grubba Gregory T · Anchorage, AKBuilt 1974 · S/N U206-02237 N2401GKidd Alexander P · Nashville, TNBuilt 1958 · S/N 51701 N2401JOne-Fifty Inc · Myerstown, PAS/N 15065501 N2401LDelta Ridge Farms LLC · Oak Grove, LAS/N 17255601 N2401RSky182 LLC · Eugene, ORS/N 18255501 N2401YBeauchamp William J · Rigby, IDBuilt 1962 · S/N 17249701 N2402LLehman Michael N · Lansing, KSBuilt 1966 · S/N 17255602 N2402RSmith Porter Allen · Aztec, NMBuilt 1964 · S/N 18255502 N2402XTeeter Ralph R · Caldwell, IDS/N 18256302 N2403GZeus Air Inc · Wilmington, DEBuilt 1958 · S/N 51703 N2403JCordell John M · Rochester, WABuilt 1966 · S/N 15065503 N2403LSeibert Richard L · Gibsonia, PABuilt 1966 · S/N 17255603 N2403QSkydive Harbor Springs Inc · Charlevoix, MIBuilt 1966 · S/N 18257603 N2403RDuck Dennis H · Jefferson City, TNBuilt 1964 · S/N 18255503 N2403UFloyd Carson K · Elberton, GABuilt 1962 · S/N 17250003 N2403YLarkin Timothy J · Pearland, TXBuilt 1962 · S/N 17249703 N2404CWatts Noah D · San Antonio, TXS/N 30704 N2404FDe Vries James S · Pacific, MOS/N 18051604 N2404LStalder David L · Amanda, OHBuilt 1966 · S/N 17255604 N2404QHoch Lance M · New Plymouth, IDFirst renewal noticeBuilt 1966 · S/N 18257604 N2404YRegistration Pending · Rexburg, IDRegistration pending, pending cancellationBuilt 1962 · S/N 17249704 N2404ZSutherland Kurt Aron · Valley View, TXBuilt 1981 · S/N 18267897 N2405GWarren Sam A Jr · Stanwood, WABuilt 1959 · S/N 51705 N2406CRopps Spraying Service Inc · Pasco, WABuilt 1954 · S/N 30706 N2406QSteely John R · Anderson, SCBuilt 1966 · S/N 18257606 N2406RSale Reported · Lincoln, NESale reportedBuilt 1964 · S/N 18255506 N2407GFaull James Aldo · Boise, IDBuilt 1958 · S/N 51707 N2407RMyers William J · Colfax, WABuilt 1955 · S/N 26784 N2407UFrancis Ronald · Fredericktown, MOBuilt 1963 · S/N 17250007 N2408CDoughnut Wings Aviation LLC · Lewes, DEBuilt 1955 · S/N 30708 N2408FDawson Brent A · Dillingham, AKS/N 18051608 N2408GEl Coyote Ranch LLC · Alzada, MTBuilt 1958 · S/N 51708 N2408JIflycali LLC · Rancho Murieta, CABuilt 1966 · S/N 15065508 N2408XWyatt David · Las Vegas, NVBuilt 1965 · S/N 18256308 N2409XHarrison Nicholas R · Midland, NCBuilt 1965 · S/N 18256309 N2409YLow Go Flyers Inc · Jonesville, LABuilt 1955 · S/N 31967 N240DMRussell Robert Q · Genoa City, WIBuilt 1977 · S/N 17269757 N240LMChamblis John L · Webb, MSBuilt 1966 · S/N 18257601 N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168 N240RG182rg LLC · Bellevue, WABuilt 1981 · S/N R18201783 N240SUOhio State University · Columbus, OHBuilt 1981 · S/N 15285153 N2410CChasin Tails Inc · Gouldsboro, MEBuilt 1954 · S/N 30710 N2410DWeaver James C · Boise, IDFirst renewal noticeBuilt 1952 · S/N 20562 N2410EKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17271272 N2410JHeinze Gregory L · Little Rock, ARBuilt 1966 · S/N 15065510 N2410LSammons Mitchell · Belgrade, MEBuilt 1966 · S/N 17255610 N2410QRegistered aircraftBuilt 1966 · S/N 18257610 N2410UYellow Breast Aviation LLC · Christiansted, VIS/N 17250010 N2410XKitsap Aviation Squadron · Southworth, WABuilt 1965 · S/N 18256310

Back to AD 87-20-03 R2