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.

N45BVGrinberg Dmitry · Austin, TXBuilt 2004 · S/N 1007N45CABas Part Sales LLC · Greeley, COBuilt 2012 · S/N 2242N45CBBruckman Monty D · Edgewood, NMS/N 2155N45CDHillair Inc Trustee · Wilmington, DEBuilt 1979 · S/N 287916467N45CHHenry Charles H · Corpus Christi, TXBuilt 1991 · S/N 10068N45CLVandeventer George W Jr · Terre Haute, INBuilt 1996 · S/N 004N45CSSadowski Curtis D · Taylorville, ILBuilt 1958 · S/N 51391N45CWRobertson Scott · Chappell Hill, TXBuilt 1970 · S/N TC-1319N45DARegistration Pending · Fairbanks, AKRegistration pendingBuilt 1969 · S/N 17258210N45DDHart Ronald A · Belleville, ILBuilt 2002 · S/N 60302N45DHMedic Choppers LLC · Springdale, ARBuilt 1969 · S/N TE-718N45DSDcd Agriculture LLC · Franktown, COS/N 18503111N45DTKaher Kevin · Groveland, CAS/N G-785N45DWLaquerre David E · Old Orchard Beach, MEBuilt 1975 · S/N D-9840N45EEVazarani Sarah · Concord, MABuilt 1971 · S/N TH-185N45EFSvetfur Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8982N45EHHalvorsen G Elwin · Reno, NVBuilt 2014 · S/N TC0609008N45ERWindmark Ridge LLC · Port Saint Joe, FLBuilt 2004 · S/N 18281498N45FMBurgner Vanessa C · Belleville, MIBuilt 1976 · S/N TH-739N45FWBleuggs Aviation LLC · Lewes, DEBuilt 1996 · S/N 3246045N45GGMcmanamay Mark E · Ann Arbor, MIBuilt 1993 · S/N 001N45GKKnievel Gerald J · Aurora, COBuilt 2001 · S/N 24104N45GPPaulson Gary L · Alexandria, MNS/N 1-0012N45GSLinde Aviation LLC · Payson, AZBuilt 1953 · S/N 34-76N45HBFlatland Flyers LLC · Lincoln, NEBuilt 1979 · S/N 238N45HCChavi LLC · Fredericksburg, TXS/N 11326N45HRGemi Inc · Lakeway, TXBuilt 2001 · S/N 27004CN45HYExecutive Aero Inc · Peyton, COBuilt 2002 · S/N 2190N45JLBows Investments LLC · Bend, ORS/N 39-148N45JNSpotts Marcus P · Nora Springs, IABuilt 2003 · S/N 0489N45JPFlood Joseph W III · Gibbstown, NJBuilt 1978 · S/N 112-HN45JVCardon Benjamin Phillip · Chubbuck, IDS/N 001N45KMDenham James W · Tall Timbers, MDBuilt 1990 · S/N 2367N45KPColvin Clu D DBA · Big Cabin, OKBuilt 1971 · S/N 401B0201N45KTBig Squirrelly LLC · Kalispell, MTBuilt 1990 · S/N 00001N45LDetruit Rene M · Phoenix, AZBuilt 1969 · S/N 426N45LCBelle Robert M · Tampa, FLBuilt 1979 · S/N E-1600N45LLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1966 · S/N 18257144N45MAR V Aviation LLC · Thatcher, AZS/N 1074-2008N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N45MCFortney Deborah S · Union City, CABuilt 1984 · S/N 1-0009N45MDMotz Daniel J · Tucson, AZBuilt 1978 · S/N 1N45MGN45mg LLC · Venice, FLS/N G-285N45MSBeech Flyers Inc · Champaign, ILBuilt 2001 · S/N E-3384N45PCEllis Kirk W · Gakona, AKBuilt 1955 · S/N 22-3145N45PESix Flying Monkeys LLC · Frisco, TXBuilt 1980 · S/N 32R-8013074N45PGRaven Aircraft LLC · Camas, WAS/N 0991N45PLLep Holdings LLC · Sheridan, WYBuilt 1987 · S/N CE1167N45PPHigh Planes Air Service In · Bismarck, NDBuilt 1998 · S/N 392-98N45PTCleaver Anthony M · Boulder, COBuilt 1976 · S/N TH-727
Back to AD 2007-04-19 R1