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.

N380CCHolmstrom Eric C · Las Vegas, NVBuilt 2001 · S/N 9934CCN380CDTomlinson Consulting LLC · Columbia, MDBuilt 2005 · S/N 1380N380CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282459N380DMWiles Shawn Lynn · Lakeland, FLBuilt 2008 · S/N 40559N380ESZak William Roy Jr · Kissimmee, FLBuilt 1997 · S/N 18280053N380KCitabria Corporation · Wilmington, DEBuilt 2011 · S/N 543-2011N380LCLorusso Jason J · Hadley, MABuilt 2022 · S/N 41905N380MA75 East Air LLC · Valparaiso, INBuilt 1999 · S/N 18280561N380MCVeturis David L · Lake Forest, CAS/N 128-1054N380MEVpc Air Inc · Cartersville, GABuilt 2000 · S/N 172S8559N380MFRegistered aircraftBuilt 2003 · S/N 0038N380MMFolk Daniel H · Urbana, ILBuilt 1995 · S/N 29-0068N380PCRhomberg Bernard B · Elm Grove, WIBuilt 1978 · S/N E-1384N380RADarnell Charles Bert · Glen Allan, MSBuilt 2005 · S/N 1380-2005N380RBShea Michael P · Nashua, NHBuilt 1987 · S/N 380N380UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 4496211N380WGGuhl Wolfgang · Marietta, GABuilt 2010 · S/N 91618N381Deal Mark A · Spartanburg, SCBuilt 1978 · S/N 3072N3810CBlake Thomas C · Vero Beach, FLBuilt 1981 · S/N TJ-335N3810DAdlard Thomas Andrew · Dinuba, CAS/N 34510N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778N3810MSurgical Innovations Inc · Suwanee, GABuilt 1978 · S/N 28-7816378N3810TN3810t LLC · Kalispell, MTS/N 28R-30125N3810ZFalcon Ridge Industries Inc · Milleville, NJBuilt 1980 · S/N E-1802N3811DRegistration Pending · Turner, MTRegistration pending, pending cancellationBuilt 1957 · S/N 34511N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200N3811TDeleon Muniz Mario Antonio · Riverside, CABuilt 1967 · S/N 28R-30126N3811WMartin Gerard A · Boston, KYBuilt 1966 · S/N 32-741N3811XBaron 55 LLC · Hanover, NHBuilt 1981 · S/N TC-2368N3812Kline Brad · Finksburg, MDBuilt 2004 · S/N 6064N38120Hudson Wilburn Joel · Rocky Face, GABuilt 1977 · S/N 28-7790520N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390N3812FGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1977 · S/N 0780N3812TGtm Services LLC · Ames, IABuilt 1967 · S/N 28R-30127N3812WTuned Up Services Inc · Waldo, FLBuilt 1966 · S/N 32-742N3812XJets And Props Corp · Reno, NVS/N 310K0212N3813FN3813f Inc · Wilmington, DEBuilt 1977 · S/N 0781N3813GOne Three Golf LLC · Cleghorn, IABuilt 1977 · S/N 310R0916N3813QBemowski Paul · Madison, WIBuilt 1981 · S/N EA-187N3813TCenturion Transportation LLC · Weatherford, OKBuilt 1967 · S/N 28R-30129N3813WTaylor Bruce W · Stroudsburg, PABuilt 1966 · S/N 32-744N3813XRegistered aircraftAssigned, pending cancellationS/N 310K0213N3813YSheppard David A · Jackson, CABuilt 1964 · S/N 21058313N38146Olson Richard H Trustee · Walla Walla, WAS/N 28-7790241N38147St Denis Robert G · Lake City, FLBuilt 1977 · S/N 28-7725251N3814DReeder Travis · Marana, AZBuilt 1957 · S/N 34514N3814FSnuffer Michael K · Reno, NVBuilt 1977 · S/N 0782N3814PJasinski Jack J · Necedah, WIS/N 22-3504N3814RCarlton Kevin · Mount Vernon, WABuilt 1970 · S/N 28-5835
Back to AD 2007-04-19 R1