OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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:80-25-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
  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.

N11PXMuehlberg Stephen E · Newcastle, OKBuilt 2018 · S/N 011N120JLCook Cecil C · Newland, NCBuilt 1996 · S/N AV1041N120NPPowelson Mark · Pataskala, OHS/N JM-1N120RROrr Samuel L · Cleveland, GABuilt 2022 · S/N 001N120TMurphy Janet A · Stafford, KSBuilt 1952 · S/N 18-2234N120TUPaula LLC · Ault, COBuilt 1946 · S/N 8934N120XPHorton Richard · Winchester, NHS/N 120N1210ACaneen Jeremy M · Wasilla, AKBuilt 1951 · S/N 18-823N121BAPapst David · Freeland, MIS/N 22-9815N1224KBoyer Larry E · Reading, PABuilt 2017 · S/N 6-5838N122CFSouthwest Aviation Specialties LLC · Tulsa, OKS/N 15282778N122CWWentz Mark T · Milpitas, CAS/N 058N1230KReeves Roy Lee · Allen, TXBuilt 1952 · S/N 3957N1239KKnutson David J · Fall City, WABuilt 2002 · S/N 001N1239YYeagley Larrie H · Acworth, GABuilt 2016 · S/N KA12069225N123DAVanderpool Tyler · Edinburg, TXS/N 798-71N123WDLindsey Larry G · Orient, OHBuilt 1979 · S/N 1329N1242WDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2012 · S/N 0001 WKBAN12465Sherburn Daniel E · Spring Lake, MIBuilt 1961 · S/N 22-9057N124BMPops Space LLC · Luther, OKBuilt 1977 · S/N 071013N124LFForsgren Lyle M · Oshkosh, WIBuilt 2015 · S/N 120465N124RPPeroyea John L II · Midlothian, TXBuilt 1978 · S/N 15282139N124TTappan East LLC · New Philadelphia, OHBuilt 1952 · S/N 18-2238N125CMKuester Austin · Oshkosh, WIBuilt 2005 · S/N 1392-2005N125FGState Of Alaska · Kodiak, AKBuilt 1951 · S/N 18-1046N125JBCollins Kenneth W · Olympia, WABuilt 1999 · S/N JB5N1265PElder George · Perryville, MOS/N 15284992N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797N127GSSanoski Gregory G · Talkeetna, AKS/N 12-273N127TBenham Charles · Lorena, TXBuilt 1952 · S/N 18-2241N128BLHoudek Dennis E · Roseburg, ORBuilt 1947 · S/N 7569N128DMTransnovia LLC · Haslett, MIBuilt 1999 · S/N 1375-99N12BNNitz Bernard F Jr · Illinois City, ILBuilt 1992 · S/N 2033N12EABrown Gary Ashton · Simpsonville, SCS/N 15279903N12GKSpacewalker 2 LLC · Ocala, FLS/N 8197SWN12NCPeck Nathan M · Leavenworth, KSBuilt 1994 · S/N 1741-LN12TSSmith Thomas R C · Suisun City, CABuilt 2001 · S/N 1353N12VEMorrison Benjamin Franklin III · Godley, TXBuilt 1983 · S/N 32365279N12VGHashimoto Noriyuki · Rumford, MEBuilt 1971 · S/N AA1A-0187N12XZ140 LLC · Birmingham, ALS/N 13182N130TWAlkire Richard P · Dayton, OHBuilt 1991 · S/N 130N131Ekstrand Marshall · Lake Stevens, WABuilt 1972 · S/N AA1B-0050N1317Steuber Edward P · Erwin, TNBuilt 1963 · S/N S700-L1N131CFBurke Christopher L · Gordon, GABuilt 1978 · S/N 15282248N131RAFlorida Institute Of Technology · Melbourne, FLBuilt 2003 · S/N 1389-2003N1325RDavison Mark L · Vacaville, CABuilt 1976 · S/N AA1B-0615N1336BDeckett William H · East Tawas, MIBuilt 1948 · S/N 5963N13375Jenkins John R · Springville, ALBuilt 2011 · S/N 215N133TTroftgruben Gregory G · Buxton, NDBuilt 1953 · S/N 18-2247N1344TMeyer Andrew E · Lincoln University, PABuilt 1982 · S/N R-12007
Back to AD 80-25-02 R2