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.

N28SXEwing Thomas Clark · Naples, FLBuilt 1997 · S/N 0429BN28TGShooting Star Services LLC · Rosamond, CABuilt 1992 · S/N 281N28TJNational Marketing And Management Services LLC · Clyde Park, MTBuilt 1979 · S/N TC-2218N28TLTml Aircraft Inc · Narrowsburg, NYBuilt 1975 · S/N 28-7515412N28UPStoddard Donald W · Great Falls, MTBuilt 1973 · S/N 28R7335386N28VFVanguard Squadron Inc · Tea, SDS/N 80861N28VTOwens Curtis R Jr · Jourdanton, TXBuilt 1978 · S/N TC-2184N28WBMulder Air Inc · Renville, MNBuilt 1968 · S/N D-8729N28WFLift Air LLC · Shortsville, NYBuilt 2010 · S/N 13046N28WJAerinova Inc · Mattoon, ILBuilt 1978 · S/N 17270054N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626N28WTHangar 14 Maintenance Solutions LLC · Santa Teresa, NMFirst renewal noticeS/N 28-2288N28WWCruse Lonnie · Chandler, AZBuilt 1967 · S/N 28-10910N28XArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1964 · S/N 347N29000Bevins William Brian · Phoenix, AZBuilt 1967 · S/N U206-1000N29001Geske Sales & Service · Enderlin, NDBuilt 1974 · S/N 17264092N29002E A B Services LLC · Cape Coral, FLBuilt 1972 · S/N 21059777N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778N29006Fancy Inc · Iowa City, IABuilt 1974 · S/N 17264093N2900ATct Aerial LLC · Waukesha, WIBuilt 1953 · S/N 30100N2900ECentaurus LLC · Ontario, CABuilt 1978 · S/N 17271368N2900FSciathan LLC · Grosse Pointe, MIBuilt 1966 · S/N 18257000N2900PBurns Travis S · Central Point, ORBuilt 1955 · S/N 22-3163N2900TEwing Richard Jr · Antelope, CABuilt 1966 · S/N 301N2900XHenslee Eric J · Grosse Ile, MIBuilt 1967 · S/N 17700300N2900YPittman John A · Gainesville, GABuilt 1962 · S/N 18253900N2900ZCheatham Paul · La Verne, CABuilt 1959 · S/N 22-6868N29018Pacific Rim Energy Inc · Henderson, NVBuilt 1967 · S/N U206-1014N2901ALa Hoz Bruno · Canyon Country, CABuilt 1979 · S/N 28-7916524N2901CBright J Tobias · Seattle, WABuilt 1954 · S/N 30801N2901KFramptom Joseph B · Little Rock, ARBuilt 1979 · S/N 18053124N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172N2901RBerry & Sons Trucking LLC · Eufaula, OKBuilt 1962 · S/N 310G0101N2901XErwin Brandon · Jacksboro, TXBuilt 1967 · S/N 17700301N2901ZSmith Roger L · Los Alamos, NMBuilt 1959 · S/N 22-6873N2902N2902 LLC · Miami, FLBuilt 1977 · S/N U20603637N29021Kough Brian R · Plant City, FLBuilt 1979 · S/N 28R-7918133N29022Unifly Inc · Lackawanna, NYBuilt 1972 · S/N 21059783N29028Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1974 · S/N 17264095N2902AMurray Kevin D · Moneta, VABuilt 1953 · S/N 30102N2902BSky Angel LLC · Sikeston, MOBuilt 1979 · S/N 28-7990538N2902CPhil Ruhnke Construction Inc · Grangeville, IDBuilt 1954 · S/N 30802N2902KRafter J Aviation LLC · Moab, UTS/N 18053125N2902LIvey Steven L · Graniteville, SCBuilt 1967 · S/N 670065N2902PHentgen Chip · Peru, INBuilt 1955 · S/N 22-3168N2902QHeihn Daniel M · Soldotna, AKS/N 18503539N2902THarber Gary · Melbourne, FLBuilt 1966 · S/N 303N2902VArnold Thomas E · Casper, WYBuilt 1947 · S/N 118N2902YTemple Adam C · Mitchell, ORBuilt 1962 · S/N 18253902N2903CWoodin Jacques C · Inglis, FLBuilt 1954 · S/N 30803
Back to AD 2007-04-19 R1