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.

N7801UDeli Rick L · Oshkosh, WIS/N 15077846 N7801XHuckins Randall A · Goddard, KSS/N 17248301 N7801ZRegistered aircraftBuilt 1963 · S/N 15059901 N78027Cramlet Kirk T · Woodlake, CABuilt 1968 · S/N 17257467 N7802FHuntting Preston I · Camp Verde, AZBuilt 1973 · S/N 18502210 N7802KMagliacano Metal Worx Inc · La Cygne, KSBuilt 1976 · S/N 18052736 N7802XDykstra Wayne A · Pipestone, MNBuilt 1961 · S/N 17248302 N7803GTomlin Jonathan S · Georgetown, OHS/N 17259503 N7803KBales Ranch Inc · Otter, MTS/N 18052737 N7803UBishop John D · Phoenix, AZBuilt 1964 · S/N 17251803 N7804GWells Adam · New Lexington, OHBuilt 1970 · S/N 17259504 N7804ZRegistered aircraftS/N 15059904 N7805AJohnson Todd M · Hudson, WIBuilt 1956 · S/N 32702 N7805GArgabright John · Waterford, OHBuilt 1970 · S/N 17259505 N7805TSanford William M · Olalla, WABuilt 1960 · S/N 47405 N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470 N7806AFullerton Paul S · St Ignace, MIBuilt 1957 · S/N 32703 N7806FTaheri Jay · Ridgewood, NJBuilt 1966 · S/N 15063906 N7806GAircraft Management Services Inc · Milton, FLBuilt 1970 · S/N 17259506 N7806KWilson David J · Palmer, AKS/N 18052740 N7806LRegistered aircraftBuilt 1976 · S/N 18264966 N7806SAeroquest LLC · Plano, TXBuilt 1978 · S/N U20604168 N7806ZRobinson Jordan P · Lexington, NCBuilt 1963 · S/N 15059906 N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472 N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473 N7807FFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1966 · S/N 15063907 N7807GLake Of The Woods Aviation LLC · Baudette, MNS/N 17259507 N7807KSutton Aircraft Salvage LLC · Palmer, AKS/N 18052741 N7807XFarwell Joseph W · Holmen, WIBuilt 1961 · S/N 17248307 N7807ZSmokovitz Joseph M · Tecumseh, MIBuilt 1963 · S/N 15059907 N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475 N7808KRegistration Pending · Fort Collins, CORegistration pendingBuilt 1976 · S/N 18052742 N7808TMckay H Samuel · Barnwell, SCBuilt 1960 · S/N 47408 N78091Stumberg Richard Kirk · Pottsboro, TXBuilt 1973 · S/N 18261747 N78092Sale Reported · Prescott Valley, AZSale reported, pending cancellationBuilt 1973 · S/N 18261748 N78095Leuer James A · Encinitas, CABuilt 1968 · S/N 17257480 N78098Fahrenkamp Russell E · Parker, AZS/N 18261749 N7809GHodge Aviation LLC · Monroe, LABuilt 1970 · S/N 17259509 N7809KAdamson Bradley R · Cody, NEBuilt 1976 · S/N 18052743 N7809UHigh Planes Aviation LLC · Waseca, MNFirst renewal noticeBuilt 1964 · S/N 17251809 N780ALas Margaritas Aviation LLC · Qulin, MOBuilt 1978 · S/N U20604463 N780BGMaw Enterprises USA LLC · Hudson, FLBuilt 1980 · S/N 17274382 N780ESFlying Pineapple LLC · Naples, FLS/N U20604272 N780HN780h LLC · Angola, INBuilt 1965 · S/N 18256595 N7810Danger Zone Aviation LLC · Ham Lake, MNBuilt 1971 · S/N 18260671 N78102Sonoma County Land Company Inc · Santa Rosa, CABuilt 1973 · S/N 18261751 N7810ABlack Diamond Soaring Inc · Oley, PABuilt 1957 · S/N 32707 N7810KBecker Michael A · La Grande, ORBuilt 1976 · S/N 18052744 N7810URasch Hellmut G · Tomball, TXS/N 17251810 N7810XCoats Benjamin F II · Ducktown, TNBuilt 1960 · S/N 17248310

Back to AD 87-20-03 R2