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.

N3830HFox Joseph Craig · Claremont, NCBuilt 1980 · S/N 24-0955N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930N3832HSwint Eric · Ardmore, OKBuilt 1980 · S/N 24-0956N3833QDowning Robert · Talent, ORBuilt 1971 · S/N 17259933N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937N383ACWest Valley Flying Club · Palo Alto, CABuilt 2001 · S/N 1383-2001N383BHAero Aircraft 13 LLC · Jacksonville, FLBuilt 1974 · S/N 17264151N383DFDream Flight LLC · Westminster, MDBuilt 1977 · S/N 17269914N3840HJzhs LLC · Charlottesville, VABuilt 1980 · S/N 24-0959N3840NDmitrich Michael A · Pleasant Grove, UTBuilt 1968 · S/N 680127N3842VN3842v LLC · Wainscott, NYBuilt 1973 · S/N 17262158N3844HJlvav8r LLC · Murphy, NCBuilt 1980 · S/N 24-0960N3844NKlauschie David A · Papillion, NEBuilt 1967 · S/N 680128N3844QSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 17259944N3845QMacon Flying Club Inc · Macon, MOBuilt 1971 · S/N 17259945N3846HLake Willis Investments LLC · Orlando, FLBuilt 1980 · S/N 24-0961N3848QWestwind Flyers LLC · Friday Harbor, WABuilt 1971 · S/N 17259948N3849QSmetana Louis V III · Blair, NEBuilt 1971 · S/N 17259949N3851HPop City Air LLC · Greenville, NCBuilt 1980 · S/N 24-0962N3852QOwens Wilbur · Rch Palos Vrd, CAS/N 17259952N3854QHafford Jay T · Stevenson, WAS/N 17259954N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958N3859NWilson Bryan J · Henderson, NCBuilt 1968 · S/N 680134N385AWoodin David G · Margate, FLBuilt 1967 · S/N 670484N385BCRobinson Eric C · Palmer, AKS/N 526-2010N385EASchuch Glenn F Jr · Dubois, PAS/N 1208-2023N385PMurphy Patrick · Brooksville, FLBuilt 1978 · S/N 15281108N385SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282997N385SPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1979 · S/N T18803452TN3860HPatriot Aviation LLC · Farwell, MIBuilt 1980 · S/N 24-1044N3861NZekic Zivojin · Austin, TXBuilt 1968 · S/N 680136N3861QLopez Mario J · Torrance, CABuilt 1971 · S/N 17259961N3862PBrown Travis Trustee · Columbia, MOS/N P21000065N3862QQ Flyers LLC · Anaheim, CABuilt 1971 · S/N 17259962N3863HFairley Maurice A · Emerald Isle, NCBuilt 1980 · S/N 24-0965N3863QCondor Air LLC · Pleasant Valley, NYBuilt 1971 · S/N 17259963N3864QEvans James · Tuolumne, CAS/N 17259964N3865QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259965N3866QOcala Aviation Services Inc · Ocala, FLBuilt 1971 · S/N 17259966N3867QLangner Dale R · Louisburg, KSBuilt 1971 · S/N 17259967N3869QNew Garden Township · Landenberg, PABuilt 1971 · S/N 17259969N386ASSandstrom Allan A · North Ogden, UTBuilt 1970 · S/N 220-70N3870QLake Waccamaw Aviation LLC · Lake Waccamaw, NCBuilt 1971 · S/N 17259970N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972N3873NGill Warren K · Colorado City, TXBuilt 1968 · S/N 680139N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973N3875HSchulz David D · Scottsdale, AZBuilt 1980 · S/N 24-0970N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980
Back to AD 80-25-07 R1