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.

N3782PWillis Bernie W · Wasilla, AKBuilt 1955 · S/N 18-4675N3782ZJordan S G · Wasilla, AKBuilt 1960 · S/N 18-7466N3783PMcdaniel Robert M · Tonasket, WAS/N 18-4678N3783ZSchulz Kevin J · Clearlake Park, CABuilt 1960 · S/N 18-7467N3784MGtf Aviation LLC · Fryeburg, MEBuilt 1947 · S/N 12-2714N3784PDavis Reid W · Wenatchee, WAS/N 18-4679N3785MSale Reported · Stanton, MNSale reportedBuilt 1947 · S/N 12-2554N3785ZHenry L Bodmer Inc · Kenmare, NDBuilt 1960 · S/N 18-7469N3786MHuismann John C · Seaside, ORBuilt 1947 · S/N 12-2715N3787AMitzel Mark A · Oregon City, ORS/N 183054N3787MWilliams Jamey P · Thompson Falls, MTBuilt 1947 · S/N 12-2553N3787ZEasterday Jay A · Wilder, IDS/N 18-7473N3788APassmore Sandra A · Lacrosse, WABuilt 1953 · S/N 18-3055N3788MHendrickson Eric J · Brunswick, MEBuilt 1947 · S/N 12-2716N3789ABilton Nicholas J · Bozeman, MTBuilt 1953 · S/N 18-3056N3789ZBockstiegel Bill · Leadville, COBuilt 1960 · S/N 18-7475N378GFFogle H Daniel III · North Salem, NYS/N 4-1185N3790ZWilbright Debra A · Le Sueur, MNBuilt 1960 · S/N 18-7477N37937Schenck Norman W · South Bound Brook, NJBuilt 1941 · S/N 6726N3793MVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 12-2718N3793ZHentges Jerry J · Morris, MNS/N 18-7479N3794PBellamy Flying LLC · Elwood, NEBuilt 1955 · S/N 18-4694N37959Collins Dennis L · Richland, WABuilt 1941 · S/N 5-839N3795MFoothills Aviation LLC · Buhl, IDBuilt 1947 · S/N 12-2722N3795ZDieffenderfer John C · Palmer, AKBuilt 1960 · S/N 18-7486N37961Gerwig Joseph L · Sutton, AKBuilt 1941 · S/N 5-832N37964Reffett John S · Eagle River, AKBuilt 1941 · S/N 5-831N3796ASpinner Family Limited Partnership · White City, ORBuilt 1953 · S/N 18-3063N37974Houston Dustin Lee · Wray, COFirst renewal noticeBuilt 1941 · S/N 4-1505N3797MNorlin William E · Greencastle, INBuilt 1947 · S/N 12-2721N3797ZMerriner Scott L · Anchorage, AKS/N 18-7492N37982Mt Air LLC · Erie, COBuilt 1941 · S/N 4-1501N3798MGrow David A · Gloucester Point, VABuilt 1947 · S/N 12-2724N3798ZLovett William E · Homer, AKBuilt 1960 · S/N 18-7493N37991Bayne Clyde O · Newcastle, WYBuilt 1941 · S/N 4-1485N37994Fairbanks Kelly E · Twin Falls, IDBuilt 1941 · S/N 4-1490N37996Birkhold Craig A · Napoleon, OHBuilt 1941 · S/N 4-1489N3799ZConley Clint A · Spring Creek, NVBuilt 1960 · S/N 18-7495N37ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-340N37JR0s9 LLC · Poulsbo, WABuilt 1955 · S/N 18-3758N37PRS & R Planes LLC · Tulsa, OKBuilt 1950 · S/N 18-90N37WPKinney Joseph B · Palmer, AKS/N 18-756N3801PKnutson Wayne R · Thompson, NDBuilt 1955 · S/N 22-3490N38028Mason Michael S · Sequim, WABuilt 1941 · S/N 5-840N3802MClick Justin T · Hobart, INBuilt 1947 · S/N 12-2562N3802ZRowland Keith E · Glennallen, AKBuilt 1960 · S/N 18-7535N38030Port Townsend Aero Museum · Port Townsend, WABuilt 1941 · S/N 5-838N3803ZDeines Gerald G · Red Lodge, MTBuilt 1960 · S/N 18-7536N38041Palmer Ronald E Trustee · Hopkinton, NHBuilt 1941 · S/N 5-841N38045William B Roark · Silverdale, WABuilt 1941 · S/N 5-861
Back to AD 99-01-05 R1