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.

N7615ZRobinson Norman D II · Salt Lake City, UTBuilt 1966 · S/N 18-8398N7616HDahmes Brad M · Hawick, MNBuilt 1946 · S/N 12-491N7617DRunyan Colton C · Ashland, ALBuilt 1957 · S/N 22-5321N7617HGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1946 · S/N 12-492N7618HBc And B LLC · Lino Lakes, MNS/N 12-493N7618KGrabousky Chad T · Halifax, PABuilt 1950 · S/N 20-435N7619KNasby Kermit R · Shelbyville, INBuilt 1950 · S/N 20-436N7620HMckinney Leonard F · Anchorage, AKBuilt 1946 · S/N 12-496N7620KBarnes Thomas M · Pittsboro, NCBuilt 1950 · S/N 20-437N7620PSopwith James T · Sacramento, CABuilt 1961 · S/N 18-7737N7621HAerial Sign Co · Melbourne, FLS/N 12-497N7622HEngler Eric M · Cass City, MIBuilt 1946 · S/N 12-516N7622KCooper Kristopher A · Hamersville, OHBuilt 1950 · S/N 20-440N7623DBaker Donald A · Macedon, NYBuilt 1957 · S/N 22-5327N7623HCowan Drew Paul · Anchorage, AKBuilt 1946 · S/N 12-498N7625HCook Susan R · Carl Junction, MOBuilt 1946 · S/N 12-500N7626KTopp Audrey · Reno, NVS/N 20-443N7627KEngwis Douglas R · Rhodes, MIS/N 20-445N7627NRanger Aviation Inc · Burlington, COBuilt 1960 · S/N 18-7379N7628KKrompacky Jozeph E · Talkeetna, AKS/N 20-446N7629KLudwick Jacob W · Dunkirk, INBuilt 1950 · S/N 20-447N762ABPlane And Simple Leasing LLC · Delano, MNBuilt 1961 · S/N 25-593N7630HRubbert Jan D · Upham, NDBuilt 1946 · S/N 12-505N7631HSeibold Bryan S · Big Lake, AKBuilt 1946 · S/N 12-506N7631KOsborne Parker E · Minden, NVS/N 20-450N7632HAndersen Dana K · Scappoose, ORBuilt 1946 · S/N 12-507N7634DRegistered aircraftS/N 22-5343N7634HHudgin James P · Murfreesboro, TNBuilt 1946 · S/N 12-509N7634KParkhurst Brock · Harlowton, MTBuilt 1950 · S/N 20-453N7635HObrien Kenneth J · Lafayette, COBuilt 1946 · S/N 12-510N7635KGrimes John A · Nevada City, CABuilt 1950 · S/N 20-454N7636KBuergel Sandra J · East Aurora, NYBuilt 1950 · S/N 20-457N7638ZBaldwin Joseph F · Windsor, COBuilt 1966 · S/N 18-8403N7641KEwert Gary P · Worthington, MNS/N 20-459N7643DDowling Matthew H · Clarksville, VABuilt 1957 · S/N 22-5352N7643HHartley George V · Anchorage, AKBuilt 1946 · S/N 12-518N7644DBeale David K · Tullahoma, TNBuilt 1957 · S/N 22-5353N7644HBunn Jesse R · Wasilla, AKS/N 12-522N7644KKlauber Robert A · Athens, TNBuilt 1950 · S/N 20-463N7645HJohnson Michaela Renee · Anchorage, AKBuilt 1946 · S/N 12-523N7645KRhoads Christopher A · New Castle, INS/N 20-464N7646DBaier Warren R · Horicon, WIS/N 22-5355N7646HHudson James W · Wasilla, AKS/N 12-524N7647KLee Andrew · Anchorage, AKBuilt 1950 · S/N 20-468N7648HBranam James G · Middletown, OHS/N 12-527N7649HRinebold Jason R · Lewiston, IDBuilt 1946 · S/N 12-528N7649KHaldeman Enterprises LLC · Vancouver, WABuilt 1950 · S/N 20-470N764MGMng Leasing LLC · Bottineau, NDS/N 18-5065N7650KAltherr James H · Fairbanks, AKBuilt 1950 · S/N 20-471N7651DLehrman Ronald L · Brownsburg, INBuilt 1957 · S/N 22-5360
Back to AD 99-01-05 R1