OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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-07-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:80-25-07-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.

N68422Kasper Sean · Killeen, TXS/N 15282291N6842UThompson Matthew S · Fowler, COBuilt 1963 · S/N 2547N6842VKoontz Stephen W · Benton, KSBuilt 1975 · S/N 21-1176N6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTBuilt 1975 · S/N 17265604N6843UBoone Joe · Madison, INBuilt 1963 · S/N 2548N68459Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1978 · S/N 15282303N6845NTriplett Jared · Mckinnon, WYS/N 680131N6845UTarrant James D · Wenatchee, WAS/N 179N68460Registration Pending · Sheridan, WYRegistration pendingBuilt 1977 · S/N 17268460N6846NBitcertificates LLC · Kalispell, MTBuilt 1968 · S/N 680132N6846UStokely Nicholas J · Wagram, NCBuilt 1963 · S/N 2551N68475California In Nice Inc · San Jose, CABuilt 1978 · S/N 15282311N68477Freiburger Thomas M · Belvedere, CABuilt 1978 · S/N 15282312N6847UFolkerts Thomas A · Roseville, CABuilt 1963 · S/N 2552N6847VSell James Leo II · Tempe, AZBuilt 1975 · S/N 22-1240N68485Dkg Cessna LLC · Flagler Beach, FLS/N 15282313N6848NWinner William B · Durango, COBuilt 1968 · S/N 680133N6848UKiefer Nathaniel Stephen · Del Rio, TXBuilt 1963 · S/N 2553N6848VHalbrooks David N · Centerville, TNS/N 22-1241N68499Sheboygan Survey LLC · Waldo, WIBuilt 1972 · S/N 241-72N6849NBig Bad Technology LLC · Hawthorne, FLBuilt 1968 · S/N 680134N6849UShipman Terry · Flossmoor, ILS/N 2554N6849VMcguire Rick · Liberty, TXBuilt 1975 · S/N 22-1242N684ACMccabe Gurney G · Watertown, NYBuilt 2011 · S/N 1459-2011N684MAThroener Mark L · Norfolk, NEFirst renewal noticeS/N 680005N68500Air Dakota Flite Inc · Hettinger, NDBuilt 1972 · S/N 364-72N68504US Liberty Holdings LLC · Caldwell, IDBuilt 1972 · S/N 369-72N68505Volara Aviation LLC · Glendale, AZS/N 322-72N68508Williams Houston · Minot, NDBuilt 1972 · S/N 374-72N68509Luvsflying Flight Training LLC · Staten Island, NYS/N 866-72N6850ULarson Steven H · Angel Fire, NMBuilt 1963 · S/N 2555N6850VCemo Management Inc · San Antonio, TXBuilt 1975 · S/N 22-1243N68511Urban Larry D · Conroe, TXBuilt 1972 · S/N 239-72N68512Ohio Aircraft Refinishing And Repair Inc · Edison, OHBuilt 1972 · S/N 32-72N68514Twin Cities Aviation Inc · Yuba City, CAS/N 325-72N68515Gator Flight LLC · Saint Cloud, FLBuilt 1972 · S/N 867-72N68517Hanna Kirk · Portland, ORS/N 37-72N68519King Michelle L · Atlanta, GABuilt 1972 · S/N 240-72N6851ECharlie Lima 1 LLC · Jacksonville, FLBuilt 1978 · S/N 17272074N6851URodier Michael P · Foley, ALBuilt 1963 · S/N 2556N6851VKing Jason G · Newnan, GABuilt 1975 · S/N 22-1244N68521Bowman Eagles Inc · Louisville, KYBuilt 1972 · S/N 244-72N68522Registration Pending · Anchorage, AKRegistration pendingBuilt 1972 · S/N 864-72N68525N917az LLC · Miami, FLBuilt 1972 · S/N 871-72N68526Vapor Global Aviation LLC · Munford, TNBuilt 1972 · S/N 869-72N68527Morton Jerry D Jr · Dade City, FLBuilt 1972 · S/N 870-72N6852HSetter Jory · Midvale, UTBuilt 1975 · S/N 17265608N6852NBrown Robert I · Youngsville, LABuilt 1968 · S/N 680136N68531Jts Aircraft LLC · Rock Hill, SCS/N 321-72N68533Sunrise Aviation Company · Santa Ana, CABuilt 1972 · S/N 873-72
Back to AD 80-25-07 R1