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.

N341TBWil Aviate LLC · Merced, CAS/N 1696N341TSSecond Delaware Corp · Moorestown, NJBuilt 1955 · S/N G-773N341TVWild Hare Enterprises LLC · Valparaiso, INBuilt 1981 · S/N 340A1277N341UMedic Choppers LLC · Springdale, ARS/N TE-826N341VHYachtphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2303MN341VTBelmont Leasing LLC · Gig Harbor, WABuilt 1964 · S/N D-7589N341ZMendoza Refugio · Fresno, CABuilt 1960 · S/N D-6510N34202Srs Aurora LLC · Saint Germain, WIBuilt 1972 · S/N 17701700N34206Jason Air Inc · Arlington, TNBuilt 1972 · S/N 17701704N34209Friesen Chevrolet Inc · Sutton, NEBuilt 1972 · S/N 17701707N3420MMoview Aviation LLC · Mountain View, MOBuilt 1977 · S/N 32R-7885007N3420NKurth Larry A · Williston, FLBuilt 1967 · S/N 680047N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384N3420QBalladares Charles V · Mandeville, LABuilt 1977 · S/N 28R-7737054N3420RBietz Jason L · Tripp, SDBuilt 1967 · S/N 18258720N3420WBuffington Brian C · Gillsville, GAS/N 32-280N3420XBurns Kevin D · Decatur, TXBuilt 1966 · S/N 3397N3421EWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 17271539N3421PLeever William L Trustee · Medford, ORBuilt 1958 · S/N 18-6775N3421USchuster Timothy A · Carrington, NDBuilt 1963 · S/N 18254821N3421XAltitude Aviation Servieces LLC · Mountain Home, IDS/N 3398N3421YMarshall Air LLC · Paso Robles, CABuilt 1979 · S/N R18201420N3422Hergenrather Michael · Spring, TXS/N U20602920N34223Strother Brenda J · Kenai, AKBuilt 1972 · S/N 17701715N34225Dexter Paul J · Orange, MABuilt 1972 · S/N 17701717N34227Neiser David R · Napavine, WABuilt 1972 · S/N 17701719N34228Thomas Andrew J · Brownsburg, INBuilt 1972 · S/N 17701720N34229Winchester Creek Aviation LLC · Waynesville, NCBuilt 1972 · S/N 17701721N3422LAwsm Inc · Grand Canyon, AZBuilt 1967 · S/N U206-0722N3422SLanders James F Jr · Mesa, AZBuilt 1964 · S/N 18255822N3422TMangon Ronald A · Petaluma, CABuilt 1967 · S/N 17700722N3422UK & M Aircraft LLC · Granbury, TXBuilt 1963 · S/N 18254822N3422YGumley Andrew J · Wasilla, AKS/N 18051922N34231Anderson Roger Q · Manassas, VABuilt 1972 · S/N 17701723N34232Nowacki James R · Brighton, MIBuilt 1972 · S/N 17701724N34233Stimpson Shawn S · Blackfoot, IDS/N 17701725N34235Nefc Inc · North Andover, MABuilt 1972 · S/N 17701726N3423SSchroeder Matt T · Riverside, CABuilt 1964 · S/N 18255823N3423TCardinal Aviation LLC · Springdale, ARBuilt 1967 · S/N 17700723N34241Lewis Mark · Ellisville, MOS/N 17701728N34242Cherokee Pilots LLC · Royersford, PABuilt 1972 · S/N 17701729N34244Eliel F John · Sequim, WABuilt 1972 · S/N 17701731N34248Lucia Arthur H · Blacksburg, VABuilt 1972 · S/N 17701732N3424CHarris Wayne H · Altamont, TNBuilt 1972 · S/N 17701727N3424RMulder Field Inc · Ivanhoe, MNS/N 18258724N3424SPickering Heavy Hauling · Fort Lupton, COBuilt 1964 · S/N 18255824N3424TWiggains David · Canyon, TXBuilt 1968 · S/N 17700724N3424WHobaugh Auto Parts Inc · Karns City, PABuilt 1965 · S/N 32-285N3424XCarroll Ronald M · Locust Grove, GABuilt 1966 · S/N 1120N3424ZSemon Sheldon W · Galt, CABuilt 1960 · S/N 22-7337
Back to AD 2007-04-19 R1