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.

N517SWStarship Aviation LLC · Northville, MIBuilt 2003 · S/N 0666N517TPAerotrust Services Corp Trustee · Wilmington, DEBuilt 2019 · S/N XL 275N517VBBoudro Vernon G · Greenview, CABuilt 2008 · S/N 70216N517WCFreedom Wings LLC · Parker, COBuilt 1993 · S/N 1809065N517WDAmundson Lee R · Chatfield, MNBuilt 2021 · S/N 02210164N5180Allen Michael G H · Casper, WYBuilt 1961 · S/N 18051077N51804Summit Aviation Inc · Belgrade, MTBuilt 2009 · S/N 172S10898N5180EMission Aviation Training Academy · Arlington, WABuilt 1959 · S/N 50480N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466N5180PN5180p LLC · Willow Springs, MOBuilt 1958 · S/N 24-201N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397N5180UAssociation Of Baptists For World Evangelism Inc · Harrisburg, PABuilt 1964 · S/N 206-0180N5180XSouthern Sky Holdings LLC · Macon, GABuilt 1969 · S/N 190N51810Jones David L · Powderly, TXS/N 224N51816Barr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281120N5181DSchrick Robert B · Firth, NEBuilt 1958 · S/N 51281N5181EMustang Sally Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9058N5181GWalton Daniel G · Troy, MOBuilt 1951 · S/N 22234N5181HRegistered aircraftBuilt 1975 · S/N 17265363N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016N5181NValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 18267562N5181PFritz Joseph L · Eufaula, OKBuilt 1958 · S/N 24-202N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216N5181XKummer Nicolas · Wenatchee, WABuilt 1969 · S/N 191N51826Van Dyke James C · Pleasant Grove, CABuilt 1980 · S/N 01VDN51827B D Aviation LLC · Sauget, ILBuilt 2002 · S/N 17281108N5182DJensen Rodney H · South Jordan, UTS/N 51282N5182ERegistered aircraftBuilt 1978 · S/N 17271756N5182GWeese C · Quinlan, TXBuilt 1951 · S/N 23206N5182HVanderpool Robert W · Red Devil, AKS/N 18503326N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469N5182PThede Dondi I · Marshall, WIBuilt 1958 · S/N 24-203N5182RHalf Wagon Innovations LLC · Cresson, TXBuilt 2000 · S/N 18280707N5182SFoster Tyler R · Levelland, TXS/N 28-7105036N5183LWolstenholme Robert F · Line Lexington, PABuilt 1984 · S/N 0001N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037N5183TMinier Tryg · Corralitos, CABuilt 1967 · S/N 16N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184GSicking Ryan · Gainesville, TXBuilt 2002 · S/N 18281104N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472N5184PBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281105
Back to AD 2007-04-19 R1