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.

N2810KWair Inc · Mount Vernon, WABuilt 1979 · S/N 18053081N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810RSeller Mark E · Hutchinson, MNBuilt 1967 · S/N 18258410N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N28110Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496513N28111Truair LLC · Shady Shores, TXBuilt 1978 · S/N 79-30909N281123b Aviation LLC · Tyler, TXBuilt 1978 · S/N 78-30889N28114Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496514N28115Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496515N2811FLien Craig C · Plains, MTBuilt 1966 · S/N 18256911N2811KHayward Houston C · Lansdale, PABuilt 1979 · S/N 18053082N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66N2811YCotti Kevin P · Plymouth, MABuilt 1961 · S/N 18253811N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804N28127Ultimate Derby LLC · Celina, TXBuilt 1979 · S/N 80-30972N28128Klaw-N5365g LLC · Wichita Falls, TXBuilt 1979 · S/N 80-30978N28129Niles Aviation Of Kansas LLC · Arkansas City, KSBuilt 1979 · S/N 80-30970N2812ABlough Christopher D · Middlebury, INBuilt 1969 · S/N CD-1233N2812DCompass Aviation Inc · Shelby, NCBuilt 2004 · S/N 10397N2812KSylvester John A · Hereford, AZBuilt 1979 · S/N 18053083N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812RBullin Keith · Bryan, TXBuilt 1967 · S/N 18258412N2812VKennison Daniel J · Las Vegas, NVFirst renewal noticeS/N 1084N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212N2812YThor And Associates Inc · Montgomery, TXBuilt 1991 · S/N 1142N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052N28130Gorman Neal H · Bend, ORBuilt 1980 · S/N 80-30981N28131Kaczmarek John F · Weatherford, TXBuilt 1978 · S/N 78-30870N28134Rowand Kent · Powell, OHBuilt 1979 · S/N 80-30975N28135Bffe Inc · Homestead, FLS/N 80-30976N28138Todd Jared · Victoria, TXBuilt 1977 · S/N 78-31142N28139Banchero Robert · Queen Creek, AZBuilt 1980 · S/N 80-30983N2813ADoig Margaret · Omaha, NEBuilt 1969 · S/N D-9057N2813FDan Air LLC · Greenville, SCBuilt 1966 · S/N 18256913N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237N28141Viking Air Inc Trustee · Wilmington, DEBuilt 1980 · S/N 80-30982N2814KMacario Mark A · Weirsdale, FLBuilt 1979 · S/N 18053085N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182N2814PSargent Wayne M · Bremerton, WABuilt 2002 · S/N WS1N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998N2814RCypress Aviation Inc · Naples, FLBuilt 1967 · S/N 18258414N2814YYankee Tango Mike LLC · Dublin, TXS/N 18253814N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728N2815FKlopping William E · Apple Valley, CAS/N 28-7916438N2815KStudniski Alois W · Saint Joseph, MNS/N 18053086
Back to AD 2007-04-19 R1