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.

N24571Erickson Karl L · Hope, MES/N 4-648N24572Brown Michael G · Rogue River, ORBuilt 1939 · S/N 4-652N2457HGordon Eric J · Bonney Lake, WABuilt 1979 · S/N 18-7909185N2457JHarrison Steven D · Rolla, MOBuilt 1979 · S/N 18-7909128N2458PMetcalf Jerry J · Liberal, KSS/N 22-2833N2459JMaxwell Mitchell Merle · Albany, ORBuilt 1979 · S/N 18-7909129N245KWCarson Cubs LLC · Yelm, WAS/N 18-2495N24614King-Mameli Laurie · Thomaston, GABuilt 1939 · S/N 3300N2461AGaller Mary D Trustee · Elysian, MNBuilt 1952 · S/N 18-1947N2462MPalmenteri Louis J · Rhome, TXBuilt 1947 · S/N 12-1549N24637Sanford Scott C · Rancho Cucamonga, CAS/N 3316N2463PCox Christopher · Flovilla, GABuilt 1955 · S/N 22-2838N2464MRosenquist Eugene C · Kasilof, AKBuilt 1947 · S/N 12-1548N2464PAdams Gregory L · Lake Stevens, WABuilt 1955 · S/N 22-2839N2464SShellabarger Edwin L · Anchorage, AKBuilt 1979 · S/N 18-7909150N2465AWhite Andrew R · Dubois, WYS/N 22-797N2466HRaven Girl LLC · Eagle River, AKS/N 18-7909187N2466MDonalds Flying Service Inc · Pantego, NCBuilt 1947 · S/N 12-1687N2466PGriffin Scott M · Springfield, OHBuilt 1955 · S/N 22-2841N2467MToelle Neill · Fairbanks, AKBuilt 1947 · S/N 12-1693N24681Horst Aviation LLC · New Holland, PABuilt 1939 · S/N 4683N2468HStallings Cameron G · Clovis, NMBuilt 1979 · S/N 18-7909191N24699Bingham Mark D · Lakewood, COS/N 4-690N2469ABossola Raymond L · Suffolk, VAS/N 22-806N2469PMccloud James C · Mokelumne Hill, CABuilt 1955 · S/N 22-2844N246ACMateski James C · Salmon, IDBuilt 1946 · S/N 12-684N246LDHoppe Nicholas J · Big Lake, AKBuilt 1952 · S/N 18-1945N24701Corry Thomas F · Rockport, TXS/N 4-687N2470HKing Bruce J · Waldport, ORBuilt 1979 · S/N 18-7909192N2470MFluckey Gary T · Homer, AKS/N 12-1551N2471ARink Raymond E · Mimbres, NMBuilt 1952 · S/N 22-809N2472MAufderhar Kenneth G · Lopez Island, WABuilt 1947 · S/N 12-1692N24737Womack Cameron M · Jackson, LAS/N 3409N2473MMcgahan Jackie L · Kenai, AKBuilt 1947 · S/N 12-1690N2473PAnderson Tony V · Pendleton, ORBuilt 1955 · S/N 22-2848N24740Dreger Jeffrey W · Poplar Grove, ILBuilt 1939 · S/N 3413N2474MAshe David J · Randle, WAS/N 12-1553N2474PSeidel William G Jr · Poway, CABuilt 1955 · S/N 22-2849N2474ZTeufel Jeffrey · North Pole, AKBuilt 1954 · S/N 18-3592N2475ABowser Dwight H · Anchorage, AKBuilt 1952 · S/N 22-818N2475MN B Tweet And Sons · Nome, AKBuilt 1947 · S/N 12-1688N2475PErickson Scott L · Omaha, NES/N 22-2796N24776Hammer Douglas · Sandia, TXBuilt 1939 · S/N 4-718N24777Wojdylak Stephen IV · Okeechobee, FLBuilt 1939 · S/N 3467N24778Pike Timothy B · Odessa, FLBuilt 1984 · S/N 3440N2477MRegistration Pending · Indianapolis, INRegistration pendingBuilt 1947 · S/N 12-1697N24788Schulze Linda K · Bloomville, OHBuilt 1939 · S/N 3449N2478PDickinson Scott S · Coeur D Alene, IDBuilt 1979 · S/N 18-8009056N24797Wyatt Greg L · Summerville, GABuilt 1939 · S/N 3446N2479AWilson Kevin B P · La Mesa, CABuilt 1952 · S/N 20-934
Back to AD 99-01-05 R1