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.

N4903DSam Air LLC · Madison, SDBuilt 1958 · S/N 51003N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270N4903NDroke Paul Dan Jr · Coalgate, OKBuilt 1979 · S/N 18267447N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451N4904JLunken Air Group LLC · Cincinnati, OHS/N 28R-30622N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271N4904PCivil Air Support LLC · Phoenix, AZBuilt 1961 · S/N 27-495N4904QFoxtrot Air LLC · Highmore, SDBuilt 1976 · S/N 18802639TN4904SO Neil Mark F · Suffolk, VABuilt 1979 · S/N R18201444N4904UMcdonald Patrick B · Brownwood, TXBuilt 1965 · S/N 21058604N4905AAnderson Ryan Alexander · Minnetrista, MNBuilt 1978 · S/N 310R1397N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664N4905JMoore Albert III · Las Vegas, NVBuilt 1968 · S/N 28R-30623N4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423TN4905UPerformance Ag Indiana · Frankfort, INS/N 21058605N4906DHutchison Robert T · Big Lake, AKBuilt 1958 · S/N 51006N4906JSeal Air LLC · San Juan Capo, CABuilt 1968 · S/N 28R-30624N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274N4906NKmq Data Acquisitions LLC · Chugiak, AKBuilt 1979 · S/N 18267450N4906SSweeney Peter Allan · Irvine, CABuilt 1979 · S/N R18201446N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158N4907JHarmon Neil A · North Chelmsford, MABuilt 1968 · S/N 28R-30625N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222N4907PTabor Conor C · Littleton, COBuilt 1961 · S/N 27-498N4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425TN4907TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250184N4907ZChristie Ian A H · Limon, COS/N 22-8492N4908Ballew Jackie C · Rogersville, MOBuilt 1962 · S/N D-7014N4908JHolm R Stan · College Place, WABuilt 1968 · S/N 28R-30626N4908PJohnson Dalton S · Sterling, AKBuilt 1962 · S/N 18-7789N4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643TN4909ANastro Kristopher Jason · Fallon, NVS/N 32306N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490BYancey Patrick D · Spirit Lake, IDS/N 1994N490CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282205N490DBPatkotak Crawford · Barrow, AKS/N U20604472N490DLWhidden William L · Lake Wales, FLBuilt 2012 · S/N 232N490EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12258N490GRWarnock Tony J · Mobile, ALS/N 97N490HPBreit Sky Aviation LLC · Sioux Falls, SDBuilt 1989 · S/N CE-1335N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399N490LLAntel Av Corp · Lewes, DEBuilt 2004 · S/N 18281432N490MLegacy Ofs Construction LLC · Stillwater, OKBuilt 1983 · S/N EA-390N490NWGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2021 · S/N 172S12757N490RRegistered aircraftBuilt 1999 · S/N 490RN490RVSmith William R · Seneca, PABuilt 2008 · S/N 20090
Back to AD 2007-04-19 R1