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.

N518ERoland Kenneth R · Tell City, INS/N R-G-H-1N518EGStyer David B · Pendleton, ORS/N 812N518GMMountain Escape LLC · Pullman, WABuilt 1953 · S/N 18-2643N518HJArmstrong Consolidated LLC · Anchorage, AKBuilt 1971 · S/N 18501930N518JGloc Aviation LLC · Afton, OKBuilt 2009 · S/N 12469N518JSDubbs Chad T · Naples, FLBuilt 2003 · S/N 3246212N518LSeehimfly LLC · Spring, TXBuilt 2003 · S/N 42028N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111N518MDGreens Aviation LLC · Lebanon, OHBuilt 2004 · S/N 1183N518MJPursuit 53 · College Station, TXBuilt 1981 · S/N U20606535N518PCJnc Holdings LLC · Mequon, WIBuilt 1977 · S/N 340A0433N518PLMoore David P Trustee · Chattanooga, TNBuilt 1975 · S/N AA5B-0144N518PUSalim Omar J · Olympia, WABuilt 1983 · S/N 172RG1135N518QLab Aviation Corp · Montville, NJBuilt 1967 · S/N TC-1038N518RMWinkelmann Pete J · North Fond Du Lac, WIBuilt 2002 · S/N 60099N518RVFehrs Aviation LLC · Seminole, TXBuilt 2011 · S/N 40518N518SDDykstra Scott E · Jenison, MIBuilt 2019 · S/N SD001N518SJWoodward Aviation LLC · Alpine, TXBuilt 2006 · S/N 11466N518SPGreater Flint Pilots Associations Inc · Flushing, MIBuilt 2000 · S/N 172S8379N518SWGilchrist Robert T · White Salmon, WABuilt 1955 · S/N 18-4389N518TPos LLC · Glencoe, MOS/N 3466N518TCBedell Gary L · Henderson, NVBuilt 2001 · S/N 9932CCN518TJJohnson Travis · Wright City, MOBuilt 1972 · S/N TC-1436N518TPFaber James A · Coppell, TXBuilt 2012 · S/N 40639N518TRCorrina Cumulus LLC · Kalispell, MTBuilt 2001 · S/N 22518N518VKingsley Kiman J · Miller, MOBuilt 1956 · S/N 32429N5190DWalden James F · Willcox, AZBuilt 1958 · S/N 51290N5190GFinney Billy D · Muncie, INBuilt 1951 · S/N 22452N5190JAoa Kissimmee Inc · Kissimmee, FLBuilt 2002 · S/N 172S9151N5190LKing Samantha M · Mcdonough, GABuilt 1967 · S/N 28-4479N5190RIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281111N5190SRobinson Richard D · Montclair, CABuilt 1970 · S/N 28-7105050N5190TMhe Aviation LLC · Las Vegas, NVBuilt 1967 · S/N 141N5191Murray Stewart · Capay, CABuilt 1968 · S/N 432N5191FArapahoe Aero Aircraft Sales LLC · Englewood, COBuilt 2002 · S/N 18281115N5191HPearce David W Trustee · Anchorage, AKBuilt 1949 · S/N 14-509N5191JN5191j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273724N5191LGravley Kevin · Wiggins, MSBuilt 1967 · S/N 28-4480N5191RKlein Alan D · Hudson, WIBuilt 1974 · S/N 17263408N5191SBomar Christopher P · Munford, TNBuilt 1980 · S/N R18201515N5191URobles Marcos F · Oracle, AZBuilt 1964 · S/N 206-0191N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N51920Wilkinson Edward H · Aspers, PABuilt 1980 · S/N 17274377N5192DJstream Lc · Sheridan, WYBuilt 1958 · S/N 51292N5192GCarey International Aviation Services LLC · Long Beach, NYBuilt 1951 · S/N 21683N5192HAlexander Steve T · Wasilla, AKS/N 14-510N5192LKirkpatrick William J · Tyrone, PAS/N 28-4481N5192SCxo Time Builder LLC · Magnolia, TXBuilt 1970 · S/N 28-7105052N5192VStippich James A · Panama City, FLS/N 172RG0464N5192XDavis Wayne W · Wakefield, RIBuilt 1969 · S/N 180
Back to AD 2007-04-19 R1