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.

N6289KPitcock Randall · Farwell, TXBuilt 1975 · S/N 15077627 N6289SLink Darryl B · Centennial, COBuilt 1967 · S/N 15067089 N6289TCiliberti Gregory J · Loveland, OHBuilt 1983 · S/N R18201961 N628DKEastgate Investments LLC · Henderson, NVBuilt 1965 · S/N 18255786 N628JCDelaney Patrick James · Marion, TXBuilt 1974 · S/N 17262911 N628MAFitzgerald Brian B · Gettysburg, PABuilt 1964 · S/N 15060912 N628RBBrown Michael C · Erie, KSBuilt 1972 · S/N 17260622 N628RDGebert Benjamin A · Hillsdale, NYBuilt 1979 · S/N R18201066 N628RGKozubek Richard R · Shady Shores, TXBuilt 1976 · S/N 177RG0992 N628TTTollen Troy J · Austin, TXBuilt 1978 · S/N 21063058 N628YTAdventist World Aviation · Wilson, NCBuilt 1977 · S/N U20603816 N62901Bates Field Aero Club Inc · Mobile, ALBuilt 1981 · S/N 17275355 N6290EConnell Mark Stephen · Melbourne, FLBuilt 1959 · S/N 46390 N6290SFloyd Brannon A · Athens, GABuilt 1967 · S/N 15067090 N6290TLittlefield Molly F · Kent, WABuilt 1964 · S/N 15060990 N6290VDelta Sierra Aviation LLC · White Salmon, WABuilt 1980 · S/N 172RG0610 N6290WLord Of The Wings LLC · Syracuse, NYBuilt 1981 · S/N P21000742 N62918Neron II LLC · New Smyrna Beach, FLS/N 17275359 N6291CSatl Ranch Aviation LLC · Midland, TXBuilt 1980 · S/N 21063857 N6291EWright Robert D Trustee · Redding, CABuilt 1983 · S/N 18268357 N6291GWaddell Lucas A · Fort Worth, TXBuilt 1970 · S/N 15071791 N6292ELucci Giacinto A Jr · Nashville, MIS/N 46392 N6292RHynes Kevin P · Wichita Falls, TXBuilt 1979 · S/N 172RG0152 N6292SAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15067092 N6292TLee Bryan L · Salinas, CABuilt 1964 · S/N 15060992 N62938Two Guys Aviation LLC · Idaho Falls, IDBuilt 1981 · S/N 17275361 N6293EWatkins Jerry G · Portland, ORBuilt 1959 · S/N 46393 N6293GMindy Limited LLC · Muscatine, IABuilt 1979 · S/N 17273588 N6293HSpace Coast Aircraft Co · Merritt Island, FLBuilt 1979 · S/N 15284150 N6293TFranks Lauren N · La Fayette, GABuilt 1964 · S/N 15060993 N62946Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275365 N6294EFlightpath Leasing LLC · Tallahassee, FLS/N 46394 N6294GGoodrich Michael O · Cogan Station, PABuilt 1970 · S/N 15071794 N6294MN6294m LLC · Boynton Beach, FLBuilt 1980 · S/N 15284657 N6294NJanzen Brian · Fort Worth, TXBuilt 1981 · S/N 18267821 N6294PMarkowich Darren K · Gilbert, AZBuilt 1978 · S/N P21000163 N6294RMitrenko Alexander V · Selinsgrove, PABuilt 1979 · S/N 172RG0154 N6294SErmel Ryan · Taylor, PABuilt 1967 · S/N 15067094 N6294TGreater Flint Pilots Association · Flushing, MIBuilt 1983 · S/N R18201962 N62953Dodge Inc · Wilmington, DEBuilt 1981 · S/N 17275367 N6295DCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272700 N6295EBuffo Perry J · Albion, NJBuilt 1959 · S/N 46395 N6295GRegistration Pending · Eliot, MERegistration pendingBuilt 1970 · S/N 15071795 N6295YSkydoc LLC · Mokena, ILBuilt 1981 · S/N 21064322 N62960Fossen Kenneth J · Omaha, NEBuilt 1981 · S/N 17275368 N6296ABarber Michael L · Igo, CABuilt 1956 · S/N 33096 N6296EKlad-Air LLC · Catlett, VABuilt 1959 · S/N 46396 N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185 N6296KMclean Lachlan · North Creek, NYBuilt 1975 · S/N 15077629 N6296THillsboro Flying Club Inc · Hillsboro, WIBuilt 1964 · S/N 15060996

Back to AD 87-20-03 R2