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.

N6453HNorth Shore Aero Club Inc · Beverly, MAS/N 18267890 N6453NUgly Johns Aircraft LLC · Afton, OKBuilt 1978 · S/N 21063028 N6453TVandermay Monty K · Santa Fe, NMBuilt 1985 · S/N R18202029 N64541Corbett William C · Havelock, NCBuilt 1975 · S/N 17265295 N64542American Patrols Inc · Midland, TXBuilt 1975 · S/N 17265296 N64543Rcr Aviation LLC · Mansfield, OHBuilt 1975 · S/N 17265297 N64545Airplane And Drone Flight Instruction LLC · Windermere, FLBuilt 1982 · S/N 17275575 N6454ERegistration Pending · Downey, CARegistration pendingS/N 46554 N6454GRoberge James F · Waterville, MES/N 17273598 N6454KFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1975 · S/N 15077711 N6454MStrickland Deirdre N · Atlanta, GABuilt 1980 · S/N 15284736 N6454SLorance Glenn E · Iola, TXBuilt 1967 · S/N 15067254 N64556D & S Aviation LLC · Spring, TXBuilt 1982 · S/N 17275578 N6455BLala Princy Jairaj · Deltona, FLBuilt 1957 · S/N 29655 N6455CPruett Steven H · Midland, TXBuilt 1980 · S/N 21063893 N6455FSan Copertino LLC · Rome, GABuilt 1975 · S/N 18264196 N6455KFlying Gators Inc · Overland Park, KSBuilt 1975 · S/N 15077712 N6455VCrown Flying Club Inc · Olathe, KSBuilt 1981 · S/N 172RG0711 N6455XGreat Basin Aviation LLC · Eagle River, AKBuilt 1961 · S/N 18050955 N6456BVintage Trainers Inc · Wilmington, DEBuilt 1956 · S/N 29656 N6456FAmb Parnell G · Portland, NDBuilt 1966 · S/N 15063056 N6456PQuad City Area Flying Eagles · Milan, ILBuilt 1981 · S/N 15285016 N6456SBecker Richard Keith · Fraser, MIBuilt 1967 · S/N 15067256 N6456UN909dw LLC · Helena, MTBuilt 1985 · S/N 21064954 N6456VRosing David · Sunland, CAS/N 172RG0712 N6456XBurgess Mark W · Greene, MEBuilt 1961 · S/N 18050956 N64575N64575 LLC · Cheyenne, WYBuilt 1982 · S/N 17275585 N6457BJcb Holdings LLC · Helena, MTBuilt 1978 · S/N 21062768 N6457DTristar Aviation Services LLC · Hendersonville, TNBuilt 1979 · S/N 17272809 N6457ENewell Michael S · Marion, OHBuilt 1959 · S/N 46557 N6457FPepper Christopher W · Memphis, TXBuilt 1966 · S/N 15063057 N6457GN19752 LLC · Toledo, WAS/N 15071957 N6457KWysong Henry D III · Kent, WABuilt 1975 · S/N 15077714 N6458AStebbins Robert B · Georgetown, TXBuilt 1956 · S/N 33258 N6458BChavez Lauren K Hollingsworth · Albuquerque, NMBuilt 1956 · S/N 29658 N6458FLejcar Matthew J · Mesa, AZBuilt 1966 · S/N 15063058 N6458LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284400 N6458VWilson David P · Lumberton, TXBuilt 1980 · S/N 172RG0714 N6459CBallair LLC · Dalhart, TXBuilt 1980 · S/N 21063895 N64608A S Air LLC · Lantana, FLS/N 17275592 N6460BSchmick Kenneth R · Fond Du Lac, WIBuilt 1956 · S/N 29660 N6460EHooks Herbert D · Templeton, PAS/N 46560 N6460FThorton Rod W · Barrington, RIBuilt 1966 · S/N 15063060 N6460HWhitetail LLC · Anchorage, AKBuilt 1979 · S/N 20700530 N6460LRichmor Aviation Inc · Scotia, NYBuilt 1980 · S/N 15284401 N6460MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284742 N6460TDavey Douglas H · Worley, IDBuilt 1985 · S/N R18202031 N64611Great North Air LLC · Shelburne, NHBuilt 1982 · S/N 17275593 N64617Melbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275594 N6461GDrewry James D · Scottsboro, ALS/N 15071961

Back to AD 87-20-03 R2