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.

N515XCPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 2016 · S/N CC19-0006N5160Historic Aircraft Restoration Museum · Maryland Heights, MOBuilt 1952 · S/N T1-6N5160DPatton Jay A · Hobbs, NMBuilt 1958 · S/N 51260N5160ELeading Edge Flight Academy LLC · Bend, ORBuilt 1978 · S/N 17271744N5160JZemnickas William V · Metamora, MIS/N 340-0550N5160LMikesell Bruce A · New Madison, OHBuilt 1967 · S/N 28-4445N5160RTownley Wren Adam T · Orwell, VTS/N 17263377N5160SJohnson Matthew N · Redgranite, WIBuilt 1970 · S/N 28-7105014N5160TBeaver Enterprises Inc · Wilmington, DEBuilt 1981 · S/N R18201827N5160XCulver Deborah M · Anchorage, AKBuilt 1969 · S/N 166N51614Stillwater Flyers LLC · Columbus, MTBuilt 1981 · S/N 17274330N51616Stardust Aviation LLC · Farmingdale, NYBuilt 1980 · S/N 17274331N5161DKnutson Wayne R · Thompson, NDBuilt 1958 · S/N 51261N5161LGonzalez Ramiro Z · Homeland, CABuilt 1967 · S/N 28-4446N5161MSamora Bobby · Corona, CAFirst renewal noticeBuilt 1978 · S/N M-2039N5161NLewis Justin R · Frederick, OKBuilt 1980 · S/N 18267552N5161PN5161p LLC · Upland, CABuilt 1958 · S/N 24-177N5161SCapen Leasing LLC · Palm City, FLBuilt 1970 · S/N 28-7105015N5161USkyler Aviation · San Diego, CABuilt 1964 · S/N 206-0161N5161XSlease Brian D · North Pole, AKS/N 167N51627Warren David T · Mobile, ALS/N 18-8562N5162DRodrigues George C · Aiken, SCBuilt 1958 · S/N 51262N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120N5162LBlue Gecko LLC · Sheridan, WYBuilt 1967 · S/N 28-4447N5162MCorcoran Thomas A · Braintree, MABuilt 1978 · S/N M-2040N5162PHorton Melody A · Diamondhead, MSBuilt 1958 · S/N 24-178N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379N5162SStramer Douglas W · Hazelton, NDBuilt 1970 · S/N 28-7105016N51635Kovaleski Thomas J · Chugiak, AKBuilt 1974 · S/N 5025CN51637South Dakota State University · Brookings, SDS/N 172S9033N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438N5163HLsn Air LLC · Morrison, COBuilt 2001 · S/N 172S8933N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553N5163LBowyer Richard A · Ormond Beach, FLS/N 28-4448N5163PReynolds David A · Blacksburg, VAS/N 24-179N5163SValley Fliers Flying Club · Auburn, WABuilt 1970 · S/N 28-7105017N5163THendrickson Duane J · Rocklake, NDBuilt 1967 · S/N 11N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267N5163VKopacz Thomas · Glen Flora, WIBuilt 1980 · S/N 172RG0457N5163WSeaton Ryan W · Savannah, TNBuilt 1961 · S/N 28-194N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746N5164FBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281082N5164MChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-50N5164NCaribbean Way Of Life Inc Trustee · Wilmington, DEBuilt 1980 · S/N 18267554N5164PUpton John B · Lakeland, FLBuilt 1958 · S/N 24-180N5164SNorthern Sky Aviation LLC · Harbor Springs, MIBuilt 1970 · S/N 28-7105018N5164WMorning Aviation LLC · Altoona, PABuilt 1961 · S/N 28-195N51659Hawk Robert S · Argyle, TXBuilt 1977 · S/N 1098N5165DHull Terri L · Weirsdale, FLBuilt 1958 · S/N 51265N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555
Back to AD 2007-04-19 R1