AD 80-07-06

Registered aircraft · 264

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-07-06')
    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-07-06')
  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.

N3809UMartus Michael · Russellville, OHBuilt 1980 · S/N WA-211N3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeBuilt 1980 · S/N WA-212N3809ZHelm Charles M · Darlington, WIBuilt 1980 · S/N WA-213N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390N3812QN3812q LLC · San Diego, CABuilt 1981 · S/N WA-214N3812UBasquit Kenneth H · Pittsburgh, PABuilt 1980 · S/N WA-215N3818ZRigney Mark E · Ponca City, OKBuilt 1981 · S/N WA-225N383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388N38384Baisden James Brett · Manassas, VABuilt 1981 · S/N WA-231N38397Registered aircraftS/N WA-232N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397N38462Krystofiak Steven · Scottsdale, AZBuilt 1981 · S/N WA-244N3846UKrystofiak Steven · Scottsdale, AZS/N WA-242N3851ZPurcell Jmes Patrick III · Bayville, NJBuilt 1981 · S/N WA-241N3857DGill Michael T · Little Rock, ARS/N WA-248N3860BFlight Club LLC · Middle River, MDS/N WA-273N38644Harper Benjamin F III · Greensboro, ALS/N WA-275N3868JParker Fred E · Portola, CABuilt 1981 · S/N WA-258N3868KBeaver Mark · Valparaiso, INBuilt 1981 · S/N WA-259N3870UJsn Aviation LLC · Huntersville, NCBuilt 1981 · S/N WA-260N400RLJacobsson Charles A · San Gabriel, CAS/N WA-104N42RRWalla Walla University · College Place, WAS/N ME-84N444FEN444fe LLC · Stuart, FLBuilt 1979 · S/N ME-142N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311N5017MNo Limits Aviation Inc · Lincoln, MTS/N ME-54N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34N5116MBend Aircraft Mechanics LLC · Bend, ORBuilt 1978 · S/N ME-39N5164MChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-50N5166MSun City Aviation LLC · Davie, FLBuilt 1978 · S/N ME-46N516MSSouth Bay Aviation Inc · Torrance, CABuilt 1979 · S/N ME-166N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5194MSunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N ME-17N5236MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-21N5283MPskd Limited LLC · Upland, CABuilt 1978 · S/N ME-25N5485MN446rh LLC · Helena, MTBuilt 1978 · S/N ME-32N54VBas Part Sales LLC · Greeley, COBuilt 1980 · S/N ME-313N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170N577FCFlight Club · Middle River, MDS/N WA-43N57RTChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N ME-172N59DLChannel Islands Aviation Inc · Camarillo, CABuilt 1979 · S/N ME-143N6001KAllred Warren D · Marshfield, MOBuilt 1979 · S/N WA-25N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123N6003RRemikin I LLC · Naperville, ILS/N ME-126N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133
Back to AD 80-07-06