AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N9765JPinson Cassandra · Chandler, AZBuilt 1967 · S/N 28-3960N9765LMartone Aviation LLC · Ocala, FLBuilt 1972 · S/N M-1383N9765MMahoney James P · Renton, WABuilt 1967 · S/N 670059N9765WShelby Gary J · Harleysville, PABuilt 1967 · S/N 28-23251N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219N9766DMayer Gregory B · Fall River Mills, CABuilt 1959 · S/N 22-6682N9766WYoung Justice P · Prairie Grove, ARS/N 28-23252N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220N9767JMatta Aviation Services LLC · Junction City, KSBuilt 1967 · S/N 28-3963N9767MMcgill James D · Tucson, AZBuilt 1967 · S/N 670061N9767PVanhorne Robert E · Centralia, ILBuilt 1974 · S/N 25-7556039N9767WBrighton Flying Club LLC · Brighton, MIBuilt 1967 · S/N 28-23254N97681Buiqui Aerospace Corp · Kissimmee, FLBuilt 1984 · S/N 17276221N9768CHansen Kurt C · Washington, UTBuilt 1978 · S/N 32-7840116N9768JOpp Prop Air LLC · Collierville, TNBuilt 1967 · S/N 28-3964N9768WEichner Cynthia A Loening · Tolland, CTBuilt 1967 · S/N 28-23255N9769FFrost Aviation Services Inc · Las Cruces, NMBuilt 2023 · S/N 28020114N9769JDubovtsev Mikhail · Wildwood, NJBuilt 1967 · S/N 28-3967N976ACNaples Air Center Inc · Naples, FLBuilt 1981 · S/N 28-8116308N976AZWl Aviation LLC · Boca Raton, FLBuilt 1976 · S/N 27-7654200N976BEAero Sphere Inc · Mcclellan, CABuilt 1979 · S/N ME-252N976CAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1979 · S/N ME228N976CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281996N976DBSchlittenhardt Ronald K · Saint Francis, KSBuilt 1975 · S/N 49N976DPKnox John R · Arvada, COBuilt 1998 · S/N 23808N976DRRed 6 Technologies LLC · Santa Monica, CABuilt 2019 · S/N PP-007N976LSSmith Lawrence B · Clovis, CABuilt 1998 · S/N 22385N976MAZephyr Ventures Inc · Wilmington, DEBuilt 1976 · S/N 13043N976MSStaten Joseph A · Kitty Hawk, NCBuilt 1976 · S/N AA5B0353N976PShahen Michael A III · Belleville, ILBuilt 2003 · S/N 97601N97702Smith Jeffrey W · Yakima, WABuilt 1984 · S/N 17276222N9770UPlegge Timothy E · Granbury, TXBuilt 1976 · S/N AA5A-0170N9770WRegistration Pending · Altus, OKRegistration pendingBuilt 1967 · S/N 28-23257N9771DHull Christian M · Palmer, AKBuilt 1959 · S/N 18-6830N9771JBuzzard Roost Aviation LLC · Marble, NCBuilt 1967 · S/N 28-4009N9771LLarson Steven E · Columbus, NEBuilt 1972 · S/N M-1402N9771QAerospec Insurance LLC · Gig Harbor, WAS/N 1254N9771TTrevisan Hugo S · Polk City, FLS/N 38-78A0200N9772WCow Dog Flyers LLC · Bozeman, MTBuilt 1967 · S/N 28-23259N9773BChagres Flight Training LLC · Albuquerque, NMBuilt 1981 · S/N 172RG1027N9773J1st Flight LLC · Granby, COBuilt 1967 · S/N 28-3972N9773UEnos Matthew · Jackson, MOBuilt 1976 · S/N AA5A0173N97749Beck Shylan · Blanding, UTBuilt 1984 · S/N 17276225N9774BWagner Michael D · Winter, WIBuilt 1981 · S/N 172RG1028N9774DRegistration Pending · Wolf Point, MTRegistration pendingBuilt 1959 · S/N 18-6835N9774FTailwind Aviation Solutions LLC · Perry, GABuilt 1997 · S/N 18280006N9774WAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17264500N97755Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276226N9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeBuilt 1981 · S/N 172RG1029N9775LLassiter Jason T DBA · Ephrata, PABuilt 1972 · S/N M-1391
Back to AD 81-18-04 R2