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.

N5885ZLewis Vincent E · Oregon, MOBuilt 1963 · S/N 22-9747N5886DAg Solutions Of West Texas LLC · Roby, TXBuilt 1959 · S/N 18-5310N5886H86h LLC · Burlington, VTBuilt 1949 · S/N 16-503N5886XPeak Investments LLC · Roanoke, VABuilt 1994 · S/N 1809088N5886ZArgabright Jeremy E · Bloomfield, MTBuilt 1963 · S/N 22-9750N5887DBragdon James O · Monticello, FLBuilt 1956 · S/N 18-5311N5888DBruce Gregory L · Yelm, WABuilt 1956 · S/N 18-5312N5888HGfeller Kent · Winona, KSBuilt 1949 · S/N 16-510N5888ZGoldberg David C · Garner, NCBuilt 1963 · S/N 22-9752N5890DCouey Robert H · Anchorage, AKS/N 18-5315N5891DRiggs J'Ann · Wasilla, AKBuilt 1956 · S/N 18-5318N5891HFelske Michael J · East Troy, WIBuilt 1949 · S/N 16-512N5892ZCarbiener Ross · Kewanee, ILBuilt 1963 · S/N 22-9756N5893HAmos Derek L · Helena, MTBuilt 1949 · S/N 16-513N5893ZKugmach LLC · Holdrege, NEBuilt 1963 · S/N 22-9758N5894ZRussell Webster K · Ridgeland, MSS/N 22-9759N5895DOgg Kevin · Sonora, CABuilt 1956 · S/N 18-5404N5895HThompson Timothy G · Kenosha, WIBuilt 1949 · S/N 16-517N5895ZMerrick Richard W · Bernville, PABuilt 1963 · S/N 22-9761N58YTatko Philip J · Middle Granville, NYBuilt 1963 · S/N 22-9652N5900ZLindsay Clyde M Jr · Rowland, NCBuilt 1963 · S/N 22-9765N5901HBerreman Jeffrey · Yakima, WAS/N 16-523N5901ZGroom Ronald Ollie · Brownwood, TXBuilt 1963 · S/N 22-9766N5902HGage Ricky D · Lewiston, IDS/N 16-526N5902ZRegistration Pending · Kenai, AKRegistration pendingBuilt 1963 · S/N 22-9767N5904HN5904h LLC · Winter Haven, FLS/N 16-524N5905HMcglochlin Bruce A · Tomales, CABuilt 1949 · S/N 16-528N5907YMueller Carri Ann M · Palmer, AKBuilt 1966 · S/N 18-8414N5908DClark Stephen N · Walnut Cove, NCBuilt 1956 · S/N 22-4570N5909HDelaney John D · Mineral Point, WIBuilt 1949 · S/N 16-533N590DCDonald Pohland J · Anchorage, AKBuilt 1958 · S/N 18-6245N5910DEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4572N5910HKlann Jason · Yorkville, ILS/N 16-534N5910ZBishop David E · Butlerville, INBuilt 1963 · S/N 22-9777N5911ZDavis Jim F · Poteau, OKBuilt 1963 · S/N 22-9778N5912DRenner David L · Ferndale, CAFirst renewal noticeBuilt 1956 · S/N 22-4574N5913DCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4575N5913HMesserla David M · Manhattan, KSBuilt 1949 · S/N 16-527N5914HFambrough Todd W · Ocala, FLBuilt 1949 · S/N 16-538N5915DMason Jack A · Reidsville, NCBuilt 1956 · S/N 22-4577N5916HHainline James L · Klamath Falls, ORBuilt 1949 · S/N 16-537N5917ZKoch Christopher P · Batavia, NYBuilt 1963 · S/N 22-9785N5918HHarvey Michael V · Port Leyden, NYBuilt 1949 · S/N 16-541N5919HKidder Robin G · Burlington, KYS/N 16-543N591KJack Brown Seaplane Base Inc · Winter Haven, FLBuilt 1940 · S/N 5560N5920DBates Matthew T · Springfield, VABuilt 1956 · S/N 22-4582N5920HZakrzewski Patrick J · Waterford, WIBuilt 1949 · S/N 16-532N5921HHoehne Michael G · Vienna, VABuilt 1949 · S/N 16-542N5922HGifford Gary W · Lighthouse Point, FLS/N 16-544N5922ZBellamy John Mark · Freeville, NYBuilt 1964 · S/N 22-9791
Back to AD 99-01-05 R1