AD 80-25-07 R1

Registered aircraft · 25,364

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.

N117PBLadue Scott B · Fate, TXBuilt 1981 · S/N 172RG0897N117RCMaresh Jeremiah · Redding, CAS/N 172RG0034N117RWAli Mohammad Usman · Fort Worth, TXBuilt 1962 · S/N 2014N117SGPowell Ryan Christopher · Bozeman, MTS/N 1358-2004N117TMRegistered aircraftBuilt 2000 · S/N 874-2000N117UMCn Aviation LLC · Gilbert, AZBuilt 1980 · S/N P21000530N117WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276264N1180MFlying Weaners Inc · Jacksonville, FLBuilt 1969 · S/N 17258680N1180UAom Aircraft LLC · Wilmington, DES/N 17266881N1181MChin David · San Jose, CABuilt 1969 · S/N 17258681N1181U404 Ltd · Pulaski, WIBuilt 1976 · S/N 17266882N11823Redbird LLC · Denver, COBuilt 1975 · S/N 17702370N11825Cardinal Rule LLC · Bryan, TXS/N 17702371N11828Schmitz John J · Jefferson City, MOBuilt 1975 · S/N 17702372N1182MHilton David T · Brooksville, FLBuilt 1969 · S/N 17258682N1182UGreen Rebecca · Colchester, CTBuilt 1976 · S/N 17266883N1183CZahorchak Jeffrey G · Harrisburg, PABuilt 1977 · S/N 17702681N1184576 Cessna LLC · Punta Gorda, FLBuilt 1975 · S/N 17702377N1184EHutchins Chad M · Colorado Springs, COBuilt 1977 · S/N 1217-77N11854Wildenberg Craig E · Menomonie, WIBuilt 1972 · S/N 825-72N1185CSturtevant Roger C Jr · The Villages, FLS/N 17702682N1185FClements Michael R · Gig Harbor, WABuilt 1979 · S/N 17272963N1185MOwen Steve · White City, ORBuilt 1969 · S/N 17258685N11861Haga Kim E · Karlsruhe, NDS/N 829-72N11868Cornelius Joel D · Thief River Falls, MNBuilt 1972 · S/N 301-72N1186EHowatt Air Inc · Langdon, NDBuilt 1977 · S/N 257-77N11870Owens Eric D · Garland, TXBuilt 1972 · S/N 12-72N1187CNc Aviator LLC · Fuquay Varina, NCBuilt 1977 · S/N 17702683N1187MMorgan Donald F · Reno, NVBuilt 1970 · S/N 17258687N1187UNiderost Greg · Ukiah, CABuilt 1976 · S/N 17266888N1188MTrim Tab LLC · Fort Collins, COBuilt 1969 · S/N 17258688N1188NLll Aviation LLC · Durango, COBuilt 1978 · S/N R18200538N1188UAurotel Aviation Inc Trustee · Wilmington, DEBuilt 1976 · S/N 17266889N118AC9 Echo LLC · Muskogee, OKBuilt 1992 · S/N 672-92N118CBN118cb LLC · Westminster, MDBuilt 1969 · S/N 202N118PCCarenbauer Paul J · Hernando, FLBuilt 1976 · S/N 17268427N118RCAscent Aviation LLC · Lander, WYBuilt 1966 · S/N 670036N118SGWilt Jared · Gardners, PABuilt 1977 · S/N R18200115N118SUSouthern Utah University · Cedar City, UTBuilt 2018 · S/N 522-2018N118TMHarper Jean · Centennial, COBuilt 2000 · S/N 1303-2000N11907Housatonic Flying Club Inc · Danbury, CTBuilt 1975 · S/N 17702380N1190MDorr Daniel B · Locust Grove, GABuilt 1969 · S/N 17258690N1191CZerfas Gary B · Rockwall, TXBuilt 1977 · S/N 17702684N1191MMoore John S · Tracy, CABuilt 1969 · S/N 17258691N1191UFlitepro Inc · Murrieta, CAS/N 17266892N1192MGaruda Aviation Inc · Miami, FLBuilt 1969 · S/N 17258692N11937Rdt Aviation LLC · Trumbull, CTS/N 17702381N1193FVoss Douglas D · Grand Island, NEBuilt 1979 · S/N 17272964N1193MEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17258693N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694
Back to AD 80-25-07 R1