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.

N3477XCoulter Jack E · Chapel Hill, NCBuilt 1966 · S/N 3420N34787Baker Herman L · Austin, TXBuilt 1973 · S/N 17702003N3478KYarber Brandon Tate · Cleveland, TNBuilt 1967 · S/N 28-23573N3478QCsc Aviation LLC · Parker, COS/N 320E-0078N3478TGuzowski Richard G · Haydenville, MABuilt 1968 · S/N 17700778N3478WDouble D Air LLC · Killeen, TXS/N 32-354N3478XCleveland Andrew D · Vancouver, WABuilt 1966 · S/N 1152N34794Schmidt Gary L · Afton, MNBuilt 1973 · S/N 17702005N34795Fox Business Advisors LLC · Mesa, AZBuilt 1974 · S/N 17702006N34796Masters David R · Troy, KSBuilt 1973 · S/N 17702007N3479RM S Davidson Enterpries Pc · Laurel, DEBuilt 1968 · S/N 18258779N3479SCook Mark C · Hutto, TXBuilt 1964 · S/N 18255879N3479TRobbins Derick Mitchell Robbins · Freeport, FLBuilt 1968 · S/N 17700779N3479WMccurdy Robert Kelly · Glendale, AZBuilt 2007 · S/N 47011TN3479XFrontier Land & Cattle LLC · Ozark, MOBuilt 1966 · S/N 1153N3479ZPhegley James R · Carlisle, INBuilt 1960 · S/N 18-7308N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347N347BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881652N347CDCulkin Daniel J Trustee · Edmond, OKBuilt 2005 · S/N 1360N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661N347DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843840N347DMSpivey Ricky S · Samson, ALBuilt 1997 · S/N 21803N347ECallahan Kevin Michael · Des Moines, WABuilt 2011 · S/N 72189N347GDNye Brian M · Independence, ORBuilt 2002 · S/N 23851N347GWAllen Air LLC · Creola, ALBuilt 1966 · S/N 28-3651N347JADepete Joseph G · Louisville, KYBuilt 1978 · S/N 340A0448N347JPPhantom Flyer LLC · Yelm, WABuilt 2003 · S/N 347N347MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881417N347RAAdamson Matthew C · Sherwood, ARBuilt 1978 · S/N 3100N347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledS/N 28-571N347STGraber Joel C · Collins, MSBuilt 2015 · S/N 0001N347TMccartney Matthew T · Lake Tapps, WABuilt 1962 · S/N D-7058N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883N347ZCasey John T · Shenandoah, TXBuilt 1960 · S/N CD-234N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017N3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeBuilt 1966 · S/N 18257480N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780N3480USoule Clauson D · Cooperstown, NYS/N 18254880N3480XLorenzi Mark E · Lancaster, OHBuilt 1966 · S/N 1154N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023N3481FWells Garry L · Scotia, NEBuilt 1966 · S/N 18257481N3481SDorman Richard E · Mesa, WABuilt 1964 · S/N 18255881N3481TEstes Kenneth · Portland, ORS/N 17700781N3481USmith Lowell A · Gresham, ORBuilt 1963 · S/N 18254881N3481WSandpiper Air LLC · Charles Town, WVBuilt 1966 · S/N 32-358N3481XN3481x LLC · Reno, NVBuilt 1966 · S/N 3421
Back to AD 2007-04-19 R1