OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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
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-10-06-R1')
    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-10-06-R1')
  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.

N201XGAdverse Yaw LLC · Albuquerque, NMBuilt 1978 · S/N 24-0490N201XHHomers Investments LLC · Coolville, OHBuilt 1977 · S/N 24-0342N201XKKiah Jeffrey James · Ormond Beach, FLBuilt 1978 · S/N 24-0496N201XNAugust Jerry R · Barberton, OHBuilt 1978 · S/N 24-0499N201XQRossi Theodor · Venice Beach, CABuilt 1978 · S/N 24-0501N201XRVlieg Roger · Gaffney, SCBuilt 1978 · S/N 24-0502N201XURousselot Lee · Midland, TXBuilt 1978 · S/N 24-0506N201XVCahill Michael F · Batavia, OHBuilt 1978 · S/N 24-0508N201XWPerceful Ronald G · Midwest City, OKBuilt 1978 · S/N 24-0483N201XXMichel Brendan Jay · Rural Hall, NCBuilt 1978 · S/N 24-0548N201XYIsmagil Rawil A · Huntington Beach, CABuilt 1978 · S/N 24-0455N201YBStonestreet Aviation LLC · Fargo, NDBuilt 1978 · S/N 24-0473N201YDBrunberg David W · Beaver Falls, PABuilt 1978 · S/N 24-0510N201YEMcwhorter Monte D · Portland, TXBuilt 1978 · S/N 24-0513N201YF2themoon LLC · Riverton, WYBuilt 1978 · S/N 24-0514N201YGN201yg LLC · Rapid City, SDBuilt 1978 · S/N 24-0515N201YHNoomen Lyle R · Currie, MNS/N 24-0516N201YJN201yj LLC · Acworth, GAFirst renewal noticeS/N 24-0517N201YKFAA Registrations LLC Trustee · St Peter JerseyS/N 24-0518N201YLDimarco Matthew J · Leonardtown, MDBuilt 1978 · S/N 24-0519N201YNCampo Aviation LLC · Houston, TXBuilt 1978 · S/N 24-0491N201YPBrocoum Michael · New York, NYBuilt 1978 · S/N 24-0512N201YVMay Richard B · Mammoth Lakes, CABuilt 1978 · S/N 24-0528N201ZCavu Holdings LLC · Medon, TNBuilt 1978 · S/N 24-0542N201ZBBrowne Michael T · Ada, OKBuilt 1978 · S/N 24-0415N201ZDFlight Eval LLC · Flagler Beach, FLBuilt 1978 · S/N 24-0749N201ZESoeby Paul R · Walhalla, NDBuilt 1978 · S/N 24-0638N201ZFForever Aviation LLC · Houston, TXBuilt 1978 · S/N 24-0650N201ZGHaugen Mark K · Newhall, CABuilt 1978 · S/N 24-0640N201ZHBailey Michael D · Dover, FLS/N 24-0535N201ZLDressler David C · Mission Viejo, CABuilt 1978 · S/N 24-0536N201ZNJp Martin Service LLC · Hialeah, FLBuilt 1978 · S/N 24-0537N201ZQReber William T · Terrace Park, OHBuilt 1978 · S/N 24-0539N201ZRYost Robert L · Bridgeport, WVBuilt 1978 · S/N 24-0540N201ZTHn Journey LLC · Lewes, DEBuilt 1978 · S/N 24-0543N201ZVLeung Michael H · Millstone Township, NJBuilt 1978 · S/N 24-0546N201ZWHoward Richard A · Venice, FLBuilt 1981 · S/N 24-1194N201ZYFlight Associates Inc · Malabar, FLS/N 24-0551N201ZZSky West Aviation Inc Trustee · Albuquerque, NMS/N 24-0745N20201Castillo Frank E · San Jose, CABuilt 1972 · S/N 17261091N20202Lolani Leasing LLC · Los Angeles, CABuilt 1972 · S/N 17261092N20203Wannenburg Thomas · Atlantic Beach, FLBuilt 1972 · S/N 17261093N20204Bellingham James G · Baltimore, MDBuilt 1977 · S/N 17702644N20207Disheroon Donald · Houston, TXS/N 17261095N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096N2020CN2020c LLC · Abilene, TXBuilt 2005 · S/N 18281700N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101
Back to AD 87-10-06 R1