OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N275BBrunsvold Gene R · Selma, ORBuilt 1970 · S/N D-9206N275BMWestchester Flying Club Inc · Purchase, NYBuilt 1966 · S/N D-8196N275EASmith Mark K DBA · Hubertus, WIS/N E-3520N275RBlue Card Aviation LLC · Conifer, COS/N TC-1885N275TCQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N E2914N2761TSmith Corey J · Liberty Township, OHBuilt 1967 · S/N D-8492N27634Middaugh Terry E · Chattaroy, WABuilt 1952 · S/N G-15N2763TOrmsby Stephen J · Somerville, OHBuilt 1967 · S/N D-8469N2764AMorse-Ellington Bruce P · Phoenix, MDBuilt 1986 · S/N E-2322N2767TCarr Jeffrey L · Hot Springs, ARBuilt 1967 · S/N D-8476N2769TRakhmatulin Evgeny A · Carlsbad, CABuilt 1967 · S/N D-8477N276BXSmith William P · Chandler, OKBuilt 1966 · S/N D-8257N276DDuval Randall Lynn · Mckinney, TXBuilt 1967 · S/N TG-5N2770ASealane LLC · Burlingame, CABuilt 1979 · S/N P-492N2771TKleine James S · New Buffalo, MIS/N D-8487N2772TRybakov Sergey N · Honolulu, HIBuilt 1967 · S/N TC-1032N2773TPovilaitis Carl A · Glendale, CABuilt 1967 · S/N TE-376N2773WStokes Robert A · Golden, COBuilt 1975 · S/N D-9720N2774TOlson Electrical Services · Reno, NVS/N D-8481N2775TWarner Jason David · Roseville, CAS/N D-8466N2776AMccarthy Brian P · Yonkers, NYBuilt 1969 · S/N D-9054N2776TGeorge John S · Abiquiu, NMS/N D-8480N2777PChilds Patrick S · Jasper, TNBuilt 1967 · S/N D-8535N2778THavrick Jason T · Bridgeport, TXBuilt 1967 · S/N TE-378N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617N277FRowland Maxwell J · League City, TXBuilt 1969 · S/N CJ-16N277FCRegistered aircraftAssigned (import), pending cancellationS/N WA-308N277JMN541mg Inc · Big Pine Key, FLBuilt 1966 · S/N TE-215N277LTBeechnutz Aviation LLC · Atlanta, GABuilt 1981 · S/N WA277N277MDRegistered aircraftBuilt 1966 · S/N TE-223N277MRSchab Davis Margaret A · Spangle, WABuilt 1966 · S/N TC-1012N277PSparks Nathan G · Knoxville, TNBuilt 1955 · S/N D-4230N277RBWaldo Pepper Flying Co · Wilmington, DEBuilt 1964 · S/N D-7473N277VCusick Christopher J · La Jolla, CABuilt 1954 · S/N CH-88N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029N2784TVerastegui Emilio F III · Albuquerque, NMBuilt 1967 · S/N D-8489N2785TPatin Carey · New Roads, LABuilt 1967 · S/N D-8501N2787TBombero Aviation LLC · Childress, TXBuilt 1967 · S/N TE-388N2789TLaycock Sean P · Plymouth, MIBuilt 1967 · S/N D-8483N278CRRittgers Timothy · Lapeer, MIBuilt 1986 · S/N CE-1089N278GTankersley Aviation LLC · Sylacauga, ALBuilt 1979 · S/N E-1547N278RHolliday Henry S · Poplarville, MSS/N E-1181N278WWWedell Williams Memorial Foundations · Patterson, LABuilt 1939 · S/N 264N2791TJoyce George E · Franklinville, NCS/N TE-384N2793THaas Mark A · Ridgecrest, CABuilt 1967 · S/N D-8499N2796TPozdolski Casey · Los Osos, CABuilt 1967 · S/N D-8491N2797ABlue Line Aviation LLC · Vidalia, GABuilt 1969 · S/N D-9055N2797TD'Angelo Brothers Development LLC · Helena, MTBuilt 1967 · S/N D-8486N2798PNautilus Air LLC · Omaha, NEBuilt 1986 · S/N E-2337N2798TPatriot Aviation Logistics LLC · Lewes, DEBuilt 1967 · S/N D-8488
Back to AD 99-05-13 R1 WD