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.

N46RVWithey Charles E · Hanson, MABuilt 1996 · S/N 20483N46SDPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8054040N46SHMoghaddas Ali · Lake Sherwood, CABuilt 1987 · S/N 172N46TESerenity Aero LLC · Cape Girardeau, MOBuilt 2005 · S/N 1694N46TFHowell George Ryan · Conway, NCBuilt 2018 · S/N 2546N46TJLile John G · Iowa Park, TXBuilt 1998 · S/N 23030N46TMCartledge Douglas J · Seville, OHS/N 24709N46UTVon Schmidt Gordon D · Waretown, NJBuilt 1973 · S/N 28R-7435068N46VCAltitude & Anchor LLC · Kalispell, MTS/N 3206N46VKMoskin Jeffrey M · Culver City, CABuilt 1973 · S/N TC-1546N46VTPh Aviation Inc · Lewes, DEBuilt 2015 · S/N 40138N46WBBullen Riley P · Kingman, AZBuilt 2000 · S/N 29-0226N46WFFoy William N · Murfreesboro, TNS/N 32-971N46WMMallia Karen W · Schenectady, NYBuilt 1997 · S/N 31N46WPPowers Phillip M · Cumberland Gap, TNS/N 60376N46YHDouglas Hiram P · Godley, TXBuilt 2025 · S/N 21026N46YMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1992 · S/N 10026N4700FAssociated Equip Representatives Inc · Yakima, WABuilt 1966 · S/N P206-0300N4700SGiddyup Flyers LLC · Danville, CABuilt 1979 · S/N R18201388N4701AWtfa LLC · Decatur, ALBuilt 1978 · S/N 414A0085N4701DMiller Larry L · Dade City, FLBuilt 1957 · S/N 34801N4701KMorgan Carl A · Mayhill, NMBuilt 1969 · S/N TE-717N4701LTrainor Jonathan P · Bridgewater, NJS/N 28-4014N4701QWindsor Greg A · Anchorage, AKBuilt 1966 · S/N 185-1155N4701SBailey Mark E · Owingsville, KYBuilt 1979 · S/N R18201389N4701URegistered aircraftBuilt 1964 · S/N 18051401N47023Morey John Jack · Port Orange, FLBuilt 1977 · S/N 28-7890049N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074N4702HAbove All Others Consulting Inc · West Palm Beach, FLBuilt 1979 · S/N 24-0812N4702KUniversity Auto Sales Inc · Pell City, ALBuilt 1975 · S/N 18263701N4702MVolant Aviation LLC · Brenham, TXBuilt 1978 · S/N D-10127N4702QDriggs Daniel H · Anchorage, AKBuilt 1966 · S/N 185-1156N4702VBrown Anthony · Pacoima, CABuilt 1967 · S/N 30053N4703AStromberg Gary J · Medicine Lake, MTS/N 18-4918N4703KSkeffington Robert C · Topsfield, MABuilt 1975 · S/N 18263702N4703LMaust Luke A · Accident, MDBuilt 1967 · S/N 28-4017N4703VLangham William Hb · Uvalde, TXBuilt 1967 · S/N 30054N4704ABrown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 18502426N4704CWright Brian A · Nampa, IDBuilt 1956 · S/N 33738N4704NScott Lester N · Pleasanton, CAFirst renewal noticeBuilt 1979 · S/N 18267294N4704PCarlson Brent · Medford, ORBuilt 1960 · S/N 27-232N4705DN4705d LLC · Oklahoma City, OKS/N 17272335N4705KYi Ranches Lp · Reedley, CABuilt 1975 · S/N 18263704N4705LHorton Kelly · Hollis, OKBuilt 1967 · S/N 28-4019N4705NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267295N4705PHam Edward E · Boring, ORBuilt 1960 · S/N 27-233N4705UIverson James P · Soldotna, AKBuilt 1964 · S/N 18051405N4706BCollegiate Peaks Aviation LLC · Salida, COBuilt 1955 · S/N 31604N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336N4706KWitman Michael R · Milliken, COBuilt 1975 · S/N 18263705
Back to AD 2007-04-19 R1