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.

N22958Primary Flight Control LLC · Fleming Island, FLBuilt 1939 · S/N 2855N22960Cleis Richard A · Kihei, HIBuilt 1939 · S/N 4-520N22966Thomas John L · Port Orange, FLBuilt 1939 · S/N 4-522N22986212 Investments LLC · Collinsville, OKS/N 2887N229TGagnon Matthew I · Fairbanks, AKS/N 18-2343N22EVMeggers Roger D · Baker, MTBuilt 1989 · S/N 1809022N22GNSkattum LLC · Sioux Falls, SDBuilt 1956 · S/N 22-3948N22KYGamma Holdings LLC · Denver, COS/N 18-3588N22MHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 18-8475N2300ACooper Brian T · Chandler, AZBuilt 1952 · S/N 22-687N2301PWheatley David L · Saltsburg, PABuilt 1955 · S/N 22-2711N2302VBeacon West LLC · Hayden Lake, IDS/N 18-4308N2304YHrutkay Charles S · Scenery Hill, PABuilt 1952 · S/N 18-2215N2305PNewell Timothy A · Beach City, OHBuilt 1955 · S/N 22-2716N2306PRicks Electric Plus LLC · Middleton, IDBuilt 1955 · S/N 22-2717N2307AFerry Donald A · Shakopee, MNBuilt 1952 · S/N 22-696N2307PMellish Everett C · La Center, WAS/N 22-2718N2308MStrate Joel R · Roberts, WIBuilt 1946 · S/N 12-1475N2308PRubbert Randy C · Reynolds, NDBuilt 1955 · S/N 22-2719N2309APlitt Benjamin T · Hortonville, WIS/N 22-698N2309MCranford Billy J · Wasilla, AKBuilt 1946 · S/N 12-1476N2309PWielinga Pieter F · Hayes, VABuilt 1955 · S/N 22-2720N230THague Creek Aviation LLC · Phoenix, AZS/N 18-2344N23101Lark Enterprises LLC · Mitchell, SDBuilt 1939 · S/N 2883N23109Shamrock Aviation LLC · Seabrook, NHBuilt 1939 · S/N 4-532N2311PCuller Stephen R · Winston Salem, NCBuilt 1955 · S/N 22-2722N2312PMoran Thomas D · Orchard Park, NYBuilt 1955 · S/N 22-2723N23132Bent James L Jr DBA · Palatine Bridge, NYBuilt 1939 · S/N 2906N2313PWright Michael · Hurricane, UTS/N 22-2724N2314ADodson John N · Hernando, MSS/N 22-703N2314MMullins Esten R · El Paso, TXBuilt 1946 · S/N 12-1478N2315MBalfany Michael D · Kingston, NVBuilt 1946 · S/N 12-1479N2315PFlood Joseph W · Franklinville, NJBuilt 1955 · S/N 22-2726N23161Shawver Aviation LLC · Knoxville, IABuilt 1939 · S/N 2943N23165Irwin Luther J · Tucson, AZBuilt 1939 · S/N 2951N2316MRed Tail Aviation LLC · Pueblo, COBuilt 1946 · S/N 12-1480N2317AHansen Craig Dan · Idaho Falls, IDBuilt 1952 · S/N 22-717N2318JMcintyre Jon D · Fairbanks, AKBuilt 1979 · S/N 18-7909100N2318MRentz Travis Kyle · Palmer, AKBuilt 1946 · S/N 12-1385N23194Alvis Michael DBA · Parkton, NCBuilt 1939 · S/N 4548N2319JGriffin Brett W · Decatur, TXBuilt 1979 · S/N 18-7909101N2319PMood Kathleen T · Carlsbad, CABuilt 1955 · S/N 22-2730N231TBates Dallas W · Slana, AKBuilt 1953 · S/N 18-2345N23200Morois Howard J · Green Bay, WIBuilt 1939 · S/N 4-556N23201Belsaas Richard A · Rapid City, SDS/N 2975N23209Mitchell Asher · Senoia, GABuilt 1939 · S/N 2985N2320HBurnett Robert B · Eagle, IDS/N 18-7909168N23211Matthews Franklin L · Mc Alpin, FLFirst renewal noticeBuilt 1939 · S/N 4-555N2321PClinton Flying Service Inc · Clinton, NCBuilt 1956 · S/N 22-2732N23226Lindstrom John A · Hammond, WIBuilt 1939 · S/N 2992
Back to AD 99-01-05 R1