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.

N3300GAir Amg LLC · Greensboro, NCBuilt 1977 · S/N TH-869N3300PDiscover Resources LLC · Norman, OKBuilt 2003 · S/N 90275N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300N3300ZKoliastasis Pete · Reno, NVBuilt 1959 · S/N 22-7231N33017Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515289N33018Lovingier Michael J · Glendale, AZBuilt 1975 · S/N 28-7515290N3301DJohnson Peter L · Chico, CAS/N 32099N3301PDramstad Flying Service LLC · Helena, MTBuilt 1958 · S/N 23-1251N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601N3301ZWood Paul S · Lawton, OKBuilt 1959 · S/N 22-7232N3302DGeorge Clifford E · Starkville, MSBuilt 1997 · S/N 3302N3302WKsnl Aero LLC · Shawnee, OKBuilt 1965 · S/N 32-137N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302N3302ZMeginnes Mark A · Tucson, AZS/N 22-7234N33030Fanopoulos Joshua J · Boise, IDS/N 28-7525139N33031Jerpbak Mark J · El Dorado Hills, CABuilt 1975 · S/N 28R-7535108N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303N3303ZZanis Paul M · Wolfeboro, NHBuilt 1959 · S/N 22-7233N33046American Eagles Flying Club · New Hudson, MIBuilt 1975 · S/N 28-7505114N33047Meise Justin · Hopewell Junction, NYBuilt 1975 · S/N 28R-7535111N3304BDoty Danial J · Talkeetna, AKBuilt 1956 · S/N 22-2119N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304N3304PBucket List Aviation LLC · San Jose, CABuilt 1958 · S/N 23-1254N3304QMcnutt Brian K · Mojave, CAS/N 320D0104N3304XPhillips Daniel J · Argusville, NDBuilt 1967 · S/N 310L-0154N3305Erwin Matthew L · Georgetown, INBuilt 1959 · S/N 24700N3305PAir Royal · Middletown, DEBuilt 1958 · S/N 23-1255N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305N33061Piper 33061 LLC · Rustburg, VABuilt 1975 · S/N 28-7505116N33064Facklair LLC · Granville, OHS/N 28-7505117N3306CSkylane Inc · Schaumburg, ILBuilt 1978 · S/N R18200269N3306DAlquist Kevin B · Edwardsville, KSBuilt 1955 · S/N 32104N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306N33075Portugues Aviation LLC · Canovanas, PRS/N 28R-7535116N33077Klug Ryan Gregory · Lincoln, NEBuilt 1975 · S/N 28-7525149N33079Devaney Aviation Inc · Palm City, FLS/N 28-7525150N3307PAlbano James R · Oakham, MAFirst renewal noticeBuilt 1958 · S/N 23-1257N3307RPhan Tam M · Charlotte, NCBuilt 1967 · S/N 18258607N3307UPatronyk Gregory M · Santa Barbara, CABuilt 1963 · S/N 18254707N3307WCowell Samuel · Easley, SCBuilt 1965 · S/N 32-144N3307XMathison John M · Vancouver, WABuilt 1967 · S/N 310L-0157N33081Tofan Ray · Chula Vista, CAS/N 28-7505119N33083Barnhill Chris · Carbondale, ILBuilt 1975 · S/N 28-7505120N33085Salsbery Scott E · Brush Prairie, WAS/N 28R-7535118N3308FBravo Hotel LLC · Lewes, DES/N 18257308N3308KHowell Harley L Jr · Colville, WABuilt 1946 · S/N 1301N3308RLocatelli Gabriel G · North Bend, ORBuilt 1967 · S/N 18258608
Back to AD 2007-04-19 R1