OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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.

N4009ZJackson R Sherer · Hayes, SDBuilt 1963 · S/N 18-7960N400MAPetersen Jacob R · Wasilla, AKBuilt 1978 · S/N 18-7809126N4010ZDickey Livestock Inc · Mackay, IDBuilt 1963 · S/N 18-7961N4011MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-2888N4012MRhode Erik D · Farmington, MNBuilt 1947 · S/N 12-2889N4012ZHronkin Jesse G · Palmer, AKBuilt 1963 · S/N 18-7963N4013ERogers Twyla M · Windham, MEBuilt 1977 · S/N 18-7809018N4013MCook Richard J II · Princeton, ILBuilt 1947 · S/N 12-2891N4014EMoriarty Gerald Joseph · Anchorage, AKBuilt 1978 · S/N 18-7809019N4014MWright James Henry · Brooksville, FLBuilt 1947 · S/N 12-2892N4016ZLong Island Soaring Assoc · Yaphank, NYBuilt 1963 · S/N 18-7966N4017EJelinek Ed · Denton, MTBuilt 1977 · S/N 18-7809021N4017MBryant Theodore M · Wasilla, AKBuilt 1947 · S/N 12-2895N4017ZB4b Co · Ridgeview, SDBuilt 1963 · S/N 18-7968N4018EWilliams Matthew S Trustee · Anchorage, AKBuilt 1977 · S/N 18-7809040N4018MCesare Anthony D · Millinocket, MEBuilt 1947 · S/N 12-2896N4018ZJarosak Peter J · Valparaiso, INBuilt 1963 · S/N 18-7969N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971N4020ZFinch Ernest B · Anchorage, AKBuilt 1963 · S/N 18-7972N4021HToth Richard C · Tinley Park, ILBuilt 1947 · S/N 12-3448N4022MBeautte James Edward · Fairland, OKBuilt 1947 · S/N 12-2899N4022ZKahn Steven H · Port Alsworth, AKBuilt 1963 · S/N 18-7974N40234Mallow David N · Rio, WVS/N 18-7509115N4023MObrien William D · Duluth, MNBuilt 1947 · S/N 12-2905N4023ZLunenschloss Michael L · Anchor Point, AKBuilt 1963 · S/N 18-7975N40246Harper Matthew C · Anchorage, AKBuilt 1975 · S/N 18-7509118N4024MSale Reported · Monroeville, ALSale reportedS/N 12-2909N4024ZBrown Timathy S · Wasilla, AKBuilt 1963 · S/N 18-7977N40260Omlid Robert L · Watford City, NDS/N 16-244N4026HParker Gerald L · Stevensville, MDBuilt 1947 · S/N 12-3454N4026ULindemann Aviation LLC · Valley City, NDS/N 18-7409147N4027HEhrenfelt Linda Mae · Pierre, SDBuilt 1947 · S/N 12-3455N4027MBoyle Fred W · Cape May, NJBuilt 1947 · S/N 12-2911N40283Keech Mark A · Fairbanks, AKBuilt 1975 · S/N 18-7509119N4028HSanoski Gregory G · Talkeetna, AKBuilt 1947 · S/N 12-3456N4028ZFlower Pot Cattle Co LLC · Arlington, AZS/N 18-7982N4029MCochrane Timothy A · Chippewa Lake, OHS/N 12-2913N4030MVan Bortel Howard G · Victor, NYBuilt 1947 · S/N 12-2914N4033ZSale Reported · Port Alsworth, AKSale reportedBuilt 1963 · S/N 18-7993N4035ZPeninsula Aero Technology Inc · Kenai, AKS/N 18-7995N4036ERieger John R · Plevna, MTBuilt 1977 · S/N 18-7809042N4036ZHockey Puck LLC · Big Lake, AKBuilt 1963 · S/N 18-7996N4037EMathews Brett G · Platte City, MOS/N 18-7809043N4037MJensen Mitchell D · Coeur D Alene, IDBuilt 1947 · S/N 12-2920N4038HWilliams Rourke Co · Fairbanks, AKBuilt 1947 · S/N 12-3465N4038ZLutz Matthew S · Lewistown, MTBuilt 1963 · S/N 18-7999N4039HReese William A Jr · Waynesboro, TNBuilt 1947 · S/N 12-3466N4039MTodd Gary L · Kasilof, AKBuilt 1947 · S/N 12-2922N4039ZMeeker Airport Inc · Meeker, COBuilt 1963 · S/N 18-8000N4040EWildman Air LLC · Mckinney, TXBuilt 1978 · S/N 18-7809045
Back to AD 99-01-05 R1