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.

N3960QLastochka LLC · Kalispell, MTBuilt 1971 · S/N 17260060N3960RLong William R · Jackson, TNBuilt 1971 · S/N 28-7105065N3960TThompson Jerry C · Goldsboro, NCBuilt 1968 · S/N 28R-30305N3960WTaylor Ryan · Lakeland, FLBuilt 1967 · S/N 32-939N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460N39610Archer Aviation LLC · Pittsburg, KSBuilt 1978 · S/N 28-7890543N3961MBluebird Aviation LLC · Bismarck, NDBuilt 1978 · S/N 28-7816392N3961PMcquivey David · St George, UTS/N 22-3639N3961RWhite Lightning 3961r LLC · Chandler, AZBuilt 1971 · S/N 28-7105066N3961TMartin Noah R · Newcastle, CABuilt 1967 · S/N 28R-30306N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461N39621Zulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 44-7995016N39626Drm Air Group Inc · Lewes, DEBuilt 1978 · S/N 32-7840171N3962DMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34662N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962N3962KFolsom Lawrence E · Millington, MDBuilt 1967 · S/N 28-23842N3962QKalstrom William M · Ekalaka, MTBuilt 1971 · S/N 17260062N3962RNifong James · Enterprise, ALBuilt 1971 · S/N 28-7105067N3962TSilvretta LLC · Kalispell, MTBuilt 1967 · S/N 28R-30307N39633Sandusky Aviation LLC · Edmond, OKBuilt 1978 · S/N 28-7916001N3963DMaplewood Flying Association Inc · Dorset, VTBuilt 1957 · S/N 34663N3963TBlessing Stephen L · Bethany, MOS/N 28R-30309N3963ZMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1962 · S/N 18-7826N39647Pcl2 LLC · Menomonie, WIBuilt 1978 · S/N 32R-7885233N3964NListowski John Paul · Galveston, TXBuilt 1968 · S/N 680008N3964PWard Scot · Belgrade, MTBuilt 1956 · S/N 22-3644N3964RPerrin Gregory R · Vail, AZBuilt 1971 · S/N 28-7105069N3964TFisher Joseph A · Conway, ARBuilt 1967 · S/N 28R-30310N3964WScheineman Wayne · Conroe, TXBuilt 2017 · S/N 1218N3965PSlaughter Don Wayne · Farmville, NCFirst renewal noticeBuilt 1956 · S/N 22-3645N3965RRamsey Brian D · Van Nuys, CABuilt 1971 · S/N 28-7105070N3965THudgin Louis B · Gilbert, AZBuilt 1967 · S/N 28R-30311N3965XDevore Randall F · Prescott, IABuilt 1975 · S/N 28-7625002N3965ZHarmon James E · Eagle River, AKBuilt 1962 · S/N 18-7850N39669Lane Community College · Eugene, ORBuilt 1978 · S/N 44-7995021N3966RBless Edward L Trustee · Hollister, CABuilt 1971 · S/N 28-7105072N3966ZLorence James E · Glennallen, AKBuilt 1962 · S/N 18-7852N3967KLakes Area Aero LLC · Pelican Rapids, MNS/N 28-23851N3967QPeterson Dennis E · Cambridge, MNBuilt 1971 · S/N 17260067N3967UKarduck Craig J · Kingsville, TXBuilt 1987 · S/N H001UN3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467N39688N39688 LLC · Provo, UTBuilt 1978 · S/N 28-7990005N3968DFallon Jeffrey C · Berlin, MABuilt 1957 · S/N 34668N3968KOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-23852N3968NJohnson David E · Sunfish Lake, MNBuilt 1968 · S/N 680009N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N3968TService Oriented Aviation Readiness (S O A R) · Bolivar, MOBuilt 1967 · S/N 28R-30315N3968WDiamond C Aviation Llcj · Gentry, ARBuilt 1967 · S/N 32-917N3968YDetray Michael S · Roy, WAFirst renewal noticeBuilt 1964 · S/N 21058468N39697Goldsmith Ronald R · Mansfield, TXBuilt 1978 · S/N 28-7990007
Back to AD 2007-04-19 R1