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.

N5212GSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1950 · S/N 21201N5212KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274012N5212NR C Sherwood Grain Co · Los Banos, CABuilt 1980 · S/N 18267574N5212TCnw Holdings LLC · Wilmington, DEBuilt 1981 · S/N R18201835N52130Horton Philip D · Wasilla, AKBuilt 1974 · S/N 18052512N52134Linden Daniel M · Mcfarland, WIBuilt 1974 · S/N 18052514N52138Davis Evan A · Wasilla, AKS/N 18052517N52139Mann Aviation Inc · Long Beach, CABuilt 1980 · S/N 17274421N5213FJefferson City Aviation Inc · Jefferson City, MOBuilt 2002 · S/N 172S9124N5213GSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1951 · S/N 21573N5213HWelding James D · Hilliards, PABuilt 1975 · S/N 17265376N5213LSchultz Lillian I · Henderson, TXBuilt 1967 · S/N 28-4505N5213MFlight Training Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 172S9127N5213RSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17263430N5213THess Garrett J · Fullerton, CABuilt 1972 · S/N 34-7250222N5213WN5213w LLC · Clarksville, TNBuilt 1961 · S/N 28-249N5213XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 177N5213YFlying High Again LLC · Mount Juliet, TNBuilt 1962 · S/N 27-2261N52145Keesecker Joel K · Sweet Home, ORBuilt 1974 · S/N 18052518N52148Registration Pending · Missoula, MTRegistration pendingBuilt 1974 · S/N 18052519N52149Meng Christopher J · Dillingham, AKS/N 18052520N5214ASweitzer Jeremy J · Peoria, AZBuilt 1956 · S/N 35414N5214BCummings Arnold L · Brownsville, CABuilt 1956 · S/N 1077N5214DMarlatt Earl D · Yuma, AZBuilt 1957 · S/N 50112N5214GKirby Sherry · Granite Falls, NCBuilt 1951 · S/N 22514N5214MS & M LLC · Nauvoo, ALBuilt 1978 · S/N M-2013N5214XHaltmann Sven · Fairbanks, AKBuilt 1969 · S/N 178N52155Jones Kermit L III · Jasper, ALBuilt 1975 · S/N 18052524N52158Runyan Pamela J · Raytown, MOBuilt 1974 · S/N 18052526N5215DAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17272453N5215EWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1978 · S/N 17271774N5215GMaynard Timothy W · Tillamook, ORBuilt 1961 · S/N 310M0023N5215JIndigo Air LLC · Newburgh, NYBuilt 2002 · S/N 172S9128N5215LMorehouse William S · Tucson, AZBuilt 1967 · S/N 28-4507N5215NFedrigo John A · Moneta, VABuilt 1980 · S/N 18267577N5215TBarr Perry L · Bethel, AKS/N 28-7225358N5215WBurns Arlen B · Bellingham, WABuilt 1961 · S/N 28-251N5215XTilghman Glen A · Houston, AKBuilt 1969 · S/N 179N52160G & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17274424N52161Odea James D · Oxford, MIBuilt 2003 · S/N 90046N52168Jin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273457N5216DSixty North LLC · Boise, IDBuilt 1957 · S/N 50114N5216MChu Philip · Surprise, AZBuilt 1978 · S/N M-2010N5216TKntl Enterprises LLC · Boise, IDBuilt 1972 · S/N 28-7205247N5216ULeopard Air LLC · Oklahoma City, OKBuilt 2002 · S/N 172S9130N5216VDeener Larry C · Lexington, KYBuilt 1980 · S/N 172RG0474N5216WSteed Moroni W · Moorcroft, WYBuilt 1961 · S/N 28-252N5216YGv Air Inc · Medford, ORBuilt 1962 · S/N 27-2264N52170Blackerby Alexander N · Eola, TXBuilt 1975 · S/N 18052534N52172Troftgruben Gregory G · Buxton, NDBuilt 1974 · S/N 18052535
Back to AD 2007-04-19 R1