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.

N412SJRegistration Pending · La Place, LARegistration pendingS/N 310-0037N412SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8322N412SSConnelly James · Spearman, TXBuilt 2022 · S/N 18283196N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558N412TGThompson Larry N · Artesia, NMBuilt 1970 · S/N 32-40916N412TKBaerresen Drake A · Corona, CAS/N 0552N412TLDelta Leasing Inc DBA · Chandler, AZBuilt 2015 · S/N 4689N412WKDuncan William T Jr · Virginia Beach, VABuilt 2003 · S/N 25855N412WMBroadwell Group Inc · Alpharetta, GABuilt 2012 · S/N 172S11175N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475N412YMurrieta Humberto · San Antonio, TXS/N D-9292N413Shearer John W · The Dalles, ORBuilt 1988 · S/N 32848N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310N4130JOur Space Properties LLC · Camdenton, MOBuilt 1966 · S/N 28-22451N4130NCentral Irrigation Supply Co · Watsonville, CABuilt 1998 · S/N 2843171N4130PKoch William L · Barre, VTBuilt 1959 · S/N 23-1610N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612N4130TSteven J Leavitt · Avondale, AZS/N 320D0030N41316Elliott Barry E · Lake Havasu City, AZBuilt 1974 · S/N 28-7415168N41318Bailey Jeffrey R · Indianapolis, INBuilt 1974 · S/N 28-7415169N4131GAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2007 · S/N 12082N4131JTomb Randall H Jr · Pittsburgh, PAFirst renewal noticeBuilt 1966 · S/N 28-22453N4131UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843199N4131VBened Enterprises LLC · Jensen Beach, FLBuilt 1998 · S/N 3246120N4131XElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1968 · S/N 230N4131ZMacarthur Clinton W · Anchorage, AKBuilt 1965 · S/N 18-8201N41320Dutchyshyn Harry V Jr · Pasadena, MDBuilt 1974 · S/N 28-7405092N41327Sharp Penny E · Ocala, FLBuilt 1974 · S/N 28-7415171N4132DDominguez Luis · Brownsville, TXBuilt 1999 · S/N 2843234N4132JDubois Aviation Inc · Chino, CABuilt 2001 · S/N 28-22454N4132QKarlen John R IV · Edwards, CABuilt 1967 · S/N 310N-0032N4132YMartin Beaux R · Calhoun, LAS/N 234-76N4132ZVertical Lift Inc · Friendship, WIBuilt 2008 · S/N 12113N41331Heath Andrew · Lafayette, INBuilt 1974 · S/N 28R-7435169N41338Andrews Limited LLC · Flint, MIBuilt 2008 · S/N 4356N4133BMachinerywatch.Com Inc · Louisa, VABuilt 1975 · S/N 75-30795N4133EHouse Larry A · Anchorage, AKBuilt 1978 · S/N 18-7809129N4133PCoulson Michael D · Zanesville, OHBuilt 1959 · S/N 23-1613N4133QGaston Prentice W Jr · Carmel, INBuilt 1967 · S/N 310N-0033N4133XAnfuso Keith · La Habra Heights, CAS/N 232N4133YBlain Gerhart · Billings, MTS/N 18052828N41342Papoutsis Thomas J · Chambersburg, PAS/N 28-7405094N41343Lkr Aviation LLC · Buckeystown, MDBuilt 1974 · S/N 28R-7435171N41348Low George D · Newport, MIBuilt 1974 · S/N 28-7425227N41349Minot Aero Center · Minot, NDBuilt 1974 · S/N 28-7415179N4134JPriebe Aviation LLC · Waseca, MNBuilt 1966 · S/N 28-22456N4134MHansen Kirk · Bayside, WIBuilt 1998 · S/N 3246124N4134SQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N TJ-18N4134TDavis Stephen · Madera, CABuilt 1999 · S/N 2843206N4134ZHuseby Terry L · Hulett, WYBuilt 1964 · S/N 18-8207
Back to AD 2007-04-19 R1