OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023N3644TArizona Air Salvage · Phoenix, AZS/N 17260849N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776N364MGCw Aviation LLC · Washta, IABuilt 1979 · S/N R18201246N3651CHately William · Anchorage, AKBuilt 1978 · S/N R18200295N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73N365BCFisher Charles P · North Charleston, SCS/N 24-1213N365JTBe-A36 Inc Trustee · Wilmington, DEBuilt 1981 · S/N 24-1130N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816N36626Farrier John M · Tillamook, ORBuilt 1973 · S/N 411-74N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73N3662CArmi LLC · Nevada, IABuilt 1978 · S/N R18200297N3665CN3665c LLC · Otsego, MNBuilt 1978 · S/N R18200299N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817N3665NElt Aviation Inc · Peewee Valley, KYBuilt 1967 · S/N 680029N3666CStrauss Kenneth W · Vashon, WABuilt 1978 · S/N R18200300N366MDN366md LLC · Salinas, CABuilt 1974 · S/N 20-0015N3671CCharlie Aviation LLC · Philpot, KYBuilt 1978 · S/N R18200302N3672CWells William · Cary, NCBuilt 1978 · S/N R18200303N3672NSonger Dylan · Veedersburg, INBuilt 1967 · S/N 680030N3673LM&M Shipshape LLC · Kalispell, MTBuilt 1978 · S/N 0820N3674NWitt Larry · Waco, TXBuilt 1967 · S/N 680032N36768Miller Thomas O · Ingalls, KSBuilt 1973 · S/N 277-73N3676LGeantil Thomas G · San Diego, CABuilt 1978 · S/N 0821N36773Scootair LLC · Alburgh, VTS/N 395-73N36774Mader David B · Biddle, MTBuilt 1973 · S/N 594-73N3678LAerojet Services Inc · Aurora, COBuilt 1978 · S/N 0822N367CRRay Samuel · Spring Hill, TNS/N R18201875N367DEHour Time Aviation LLC · Granbury, TXBuilt 1977 · S/N 20-1245N3684CFly Away Aviation LLC · Folsom, LABuilt 1978 · S/N R18200307N3684LLucke Eva DBA · Minot, NDBuilt 1978 · S/N 0819N3687HRunia Allan D Trustee · Gold Hill, ORS/N 24-1040N3689CR D Management LLC · Central City, NEBuilt 1978 · S/N R18200309N368BCAugustina Holdings LLC · Argyle, TXS/N 182-68517N368CPWilliams Truman V · Robbinsville, NCBuilt 1980 · S/N R18201580N3691NGalvan Peter R · Slidell, LAS/N 680038N3694NWheeler Kevin J · Concord, CABuilt 1967 · S/N 680039N3695COrton Dennis · Mead, COBuilt 1978 · S/N R18200312N3696CTb Services LLC · Huntsville, ALBuilt 1978 · S/N R18200313N3698NKienitz David A · Buffalo Lake, MNBuilt 1967 · S/N 680041N369ADManston Quinton A · White, GABuilt 1977 · S/N 17269479N369DMHoll Brian E · Chugiak, AKBuilt 1975 · S/N 830-75N369ERTower Aviation Management LLC · Decatur, TXFirst renewal noticeS/N 172RG0062N369GBStork 1 LLC · Green Cove Springs, FLBuilt 1981 · S/N 15285103N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049
Back to AD 80-25-07 R1