Registered aircraft · 54,017

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.

N3859VK3 Safe Air LLC · Mokena, ILBuilt 1975 · S/N 15076638 N3859YMorse Donald W · Priest Lake, IDFirst renewal noticeS/N 21058359 N385CHL H Aviation LLC · Clanton, ALBuilt 1966 · S/N 17255354 N385PMurphy Patrick · Brooksville, FLBuilt 1978 · S/N 15281108 N385SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282997 N385SPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1979 · S/N T18803452T N385TDHomestead Helicopters Inc · Missoula, MTBuilt 1965 · S/N T210-0072 N3860LLake Area Technical College · Watertown, SDBuilt 1965 · S/N 17254029 N3860URana Jet LLC · Aubrey, TXS/N 336-0160 N3861CBuben Michael · Chandler, AZBuilt 1954 · S/N 31009 N3861LSeverson Marshall G · Anchorage, AKBuilt 1966 · S/N 17254030 N3861QLopez Mario J · Torrance, CABuilt 1971 · S/N 17259961 N3861RShawn James Robert · Pattison, TXS/N 17255361 N3861VVan Zant Mark · Zionsville, INBuilt 1949 · S/N 18748 N3861YMiller Todd D · Fort Wayne, INBuilt 1964 · S/N 21058361 N3862DReady Aim Flyer LLC · New Castle, DES/N 34562 N3862GRenfro Michael W · Bethel, AKS/N U206-0862 N3862JDoyle Ethan Mackenzie · Nunda, NYBuilt 1966 · S/N 15065162 N3862LSainsbury James L · Milton, WIBuilt 1965 · S/N 17254031 N3862PBrown Travis Trustee · Columbia, MOS/N P21000065 N3862QQ Flyers LLC · Anaheim, CABuilt 1971 · S/N 17259962 N3863DDulley Tony A · Nine Mile Falls, WABuilt 1957 · S/N 34563 N3863QCondor Air LLC · Pleasant Valley, NYBuilt 1971 · S/N 17259963 N3863ROkeefe Dennis G · Cincinnati, OHBuilt 1966 · S/N 17255363 N3863SRegistration Pending · Walker, MNRegistration pending, pending cancellationBuilt 1963 · S/N 17251063 N3864LDelvalle Dean · Schertz, TXBuilt 1965 · S/N 17254033 N3864QEvans James · Tuolumne, CAS/N 17259964 N3864RR Thimesch Construction LLC · Spivey, KSS/N 17255364 N3865JAlbert Bruce F · Dallas, TXBuilt 1966 · S/N 15065165 N3865LRibeiro Marcos Felix · Okeechobee, FLS/N 17254034 N3865QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259965 N3865SIndy Air Sales LLC · Anderson, INBuilt 1963 · S/N 17251065 N3866CProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 31014 N3866LLamb Daniel A · Cheyenne, WYBuilt 1966 · S/N 17254035 N3866QOcala Aviation Services Inc · Ocala, FLBuilt 1971 · S/N 17259966 N3866SKnutson Steven O · Wickenburg, AZBuilt 1963 · S/N 17251066 N3866YMessina Jacob · Copley, OHBuilt 1964 · S/N 21058366 N3867CKrmo Aviation LLC · Duluth, MNFirst renewal noticeBuilt 1954 · S/N 31015 N3867DPrestige Air Worldwide LLC · Seneca, SCBuilt 1957 · S/N 34567 N3867JOmura Alexander K · Missoula, MTBuilt 1966 · S/N 15065167 N3867LDorsey Levi Rondall · Demorest, GABuilt 1965 · S/N 17254036 N3867QLangner Dale R · Louisburg, KSBuilt 1971 · S/N 17259967 N3867RHowser Timmy L · Batavia, OHBuilt 1966 · S/N 17255367 N3867SMakee Markus J · Painesville, OHBuilt 1964 · S/N 17251067 N3867VMurat Armand · Granger, INBuilt 1949 · S/N 18754 N3867YGallagher Robert B · Rio Oso, CABuilt 1964 · S/N 21058367 N3868DRegistered aircraftBuilt 1957 · S/N 34568 N3868QLibbys Sporting Camps Inc · Chapman, MEBuilt 1973 · S/N 18502205 N3868VSwift Stephen D · Flower Mound, TXBuilt 1949 · S/N 7329 N3869DOwens Hay LLC · Crane, ORBuilt 1957 · S/N 34569

Back to AD 87-20-03 R2