AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108N2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1967 · S/N 18258415N2815YFlakes LLC · Fort Worth, TXBuilt 1962 · S/N 18253815N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78N28166Lark Thomas · Coppell, TXBuilt 1978 · S/N 79-30910N28168Walker Investment Co Construction · Cookeville, TNBuilt 1978 · S/N 79-30912N28169Zollars Byron · Georgetown, TXBuilt 1979 · S/N 79-30937N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451N2816KVigna Douglas Del · Portland, MEBuilt 1979 · S/N 18053087N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216N28170Stracar Miro · Syosset, NYBuilt 1991 · S/N 1157N28177Perez Philip G · Ft Worth, TXBuilt 1978 · S/N 78-30883N28179Canto Aviation LLC · Buxton, NCBuilt 1979 · S/N 79-30923N2817ARamey Shane · Buffalo, WYBuilt 1953 · S/N 30017N2817C2817c Inc · Wilmington, DEBuilt 1978 · S/N R18200231N2817D2b Group LLC · West Dundee, ILBuilt 1979 · S/N 28-7990455N2817LHopkins Dennis L · Bark River, MIBuilt 1979 · S/N 28-7990456N2817RHunt Loren M · Nevada, MOBuilt 1969 · S/N 28R-35298N28181Cheslar Aviation LLC · Lewes, DEBuilt 1978 · S/N 78-30905N28189Knipe Ronald C · Orlando, FLBuilt 1979 · S/N 79-30932N2818AHengemuhle Ronald J · Long Prairie, MNBuilt 1979 · S/N 28-7990459N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334N2818FMccullough Andrew · Lubbock, TXS/N 18256918N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462N2818PHancock Timothy R · Malinta, OHBuilt 1955 · S/N 22-3111N2818SAviator Antics LLC · Grand Forks, NDBuilt 1979 · S/N 28-7990466N2818TLb33 LLC · Helena, MTBuilt 1972 · S/N 28-7225239N2818XBarr Suzanne Renee · Cape Coral, FLBuilt 1979 · S/N 28-7990467N2818YEaton Melvin W II · Saint Onge, SDS/N 18253818N2818ZJohnston Charles W C · Newfield, NJS/N 22-6811N28191Ashurst Joe D · Wheatland, WYBuilt 1979 · S/N 79-30913N28195Richard C Rinks & Assoc Inc · Cookeville, TNBuilt 1979 · S/N 79-30938N28199Guppy Aviation LLC · New Smyrna Beach, FLBuilt 1990 · S/N 1062N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469N2819FMacair LLC · Kennesaw, GABuilt 1979 · S/N 28R-7918156N2819LMason Timothy F · Effingham, ILS/N 1116N2819PRector David F · Akron, OHBuilt 1955 · S/N 22-3112N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819N2819TMelvin Haigis Jr · Bardstown, KYBuilt 1972 · S/N 28-7205227N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219N281AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281189N281ARKing Scott · Knoxville, TNBuilt 1978 · S/N TH-991N281AWWebb Alan J · Medford, ORS/N 256N281BAnderson David R · Sycamore, ILBuilt 1959 · S/N 140N281BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842280N281BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881665N281BMMcilroy Bob · Charlotte, NCBuilt 1979 · S/N 79-30933
Back to AD 2007-04-19 R1