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.

N4166HBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843119N4166MWoolace James L · North Pole, AKBuilt 1947 · S/N 12-3065N4166QMays Kevin E · West Liberty, KYS/N 310N-0066N4166RRogers John K · Statesboro, GABuilt 2026 · S/N 92273N4166SBurgess Stephan H · Nags Head, NCBuilt 1975 · S/N CE-569N41674Swift Museum Foundation Inc · Athens, TNBuilt 1942 · S/N 101N41677Northern Aviation LLC · Palmer, AKBuilt 1973 · S/N 585-73N41678Dodge Donald V · Newnan, GAS/N 586-73N4167GW J Medical Consulting · Caguas, PRBuilt 1976 · S/N 402B1214N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318N4167PAeroplace Services Inc · Denison, TXBuilt 1965 · S/N TF-23N4167QHawkeye Helicopter LLC · Lyndon, KSBuilt 1968 · S/N 310N-0067N4167ZGolden Arrow Aviation Inc · Wilmington, DEBuilt 1965 · S/N 18-8349N41681Ralston Michael J · Calhoun, GABuilt 1973 · S/N 397-73N41684Nenahlo Thomas L · Anchorage, AKS/N 588-73N41686Atx Aero LLC · Austin, TXBuilt 1973 · S/N 398-73N4168HCordell Brad · Port Charlotte, FLBuilt 1995 · S/N 1263N4168JTwigg Donald A · Cumberland, MDBuilt 1966 · S/N 28-22503N4168ZRc Aviation LLC · Grimes, IABuilt 2000 · S/N 3246169N41691Whiteknucle Aerobatics Inc · Blacksburg, VABuilt 1973 · S/N 591-73N41694Damiano Charles J · Orcutt, CABuilt 1973 · S/N 400-73N41695Guilfoyle Robert J · Shepherd, MTBuilt 1973 · S/N 593-73N41696Aaa Aviation LLC · Donalsonville, GABuilt 1973 · S/N 116-73N4169FRoelker Randall S · San Antonio, TXBuilt 1976 · S/N 28-7715007N4169QMarasovich Christopher · Youngstown, OHBuilt 1968 · S/N 310N-0069N4169SHp Aero Vantage LLC · Sand Springs, OKBuilt 1975 · S/N CE-570N4169TMiller Kenneth · Henderson, NVBuilt 2003 · S/N 3257313N4169XNusom William J · Hollis Center, MEBuilt 1969 · S/N 347N4169YVanderhoof Chad T · Elk, WAS/N 185-0369N416APKizer Bret · Albany, ORS/N 47009TN416BRSeiler Valerie K Trustee · Hoffman Estates, ILBuilt 1987 · S/N CE-1187N416BWKestrel Flying LLC · Mountain Green, UTBuilt 2010 · S/N 73452N416CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881121N416CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12504N416CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N 18282416N416DMcginnis Aviation LLC · Kentwood, MIBuilt 1974 · S/N TH-500N416FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC016N416FRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11444N416GWidhalm Chelsea · Yakima, WABuilt 2002 · S/N 0310N416GFHahn Steven P · Hutchinson, MNBuilt 1964 · S/N D-7497N416HHRotorwing LLC · Sheffield, ILBuilt 1997 · S/N 0415N416HPKt7 Aviation LLC · Katy, TXBuilt 1963 · S/N 28-1437N416JLCondren Ryan · Sunnyvale, TXBuilt 1967 · S/N 28-23944N416JSC Randy Landis Dds Inc · Oroville, CABuilt 1973 · S/N TH-416N416LDLake Cumberland Helicopter Tours LLC · Monticello, KYBuilt 2006 · S/N 11252N416MKSmith Jason · Cresson, TXBuilt 1967 · S/N TE-426N416PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843438N416RARegistration Pending · Muskegon, MIRegistration pendingBuilt 1980 · S/N 414A0486N416RBWhite Jared William · Grass Valley, CABuilt 1972 · S/N 95N416RHMckamey Robert S · Tullahoma, TNBuilt 1994 · S/N 662
Back to AD 2007-04-19 R1