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.

N410RBAero Management LLC · Land O Lakes, FLBuilt 2007 · S/N 40371N410RDVan Den Langenbergh Raymond · New Port Richey, FLS/N 18-4920N410RFFeldtman Robert W · Buckholts, TXBuilt 1974 · S/N 18263478N410RVVans Aircraft Inc · Aurora, ORBuilt 2003 · S/N 1N410RWButler National Inc · New Century, KSBuilt 1982 · S/N E-2031N410SAHanson Chad L · Hillsboro, NDBuilt 1986 · S/N 559N410SFKoehler Gregory S · Burlington, NCBuilt 1965 · S/N 28-21000N410SJSutton Michael S · Arvada, COBuilt 2011 · S/N 90862N410SLEngkvist Robert D · Esmond, NDBuilt 2014 · S/N 2384N410T410t LLC · Kennett Square, PABuilt 1988 · S/N CE-1239N410TCNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881088N410TJWeselmann Brian D · Edgewater, FLBuilt 2019 · S/N 41332N410TSShort Thomas M · Noblesville, INBuilt 2016 · S/N JS-02N410TTWerhan Alan · Rockford, WAS/N 0007N410TWRice Dwight L · Borger, TXBuilt 2008 · S/N 411044N410TXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 22007CN410VFour Ten Flyers LLC · Florissant, MOBuilt 2014 · S/N 40004N410WBHines Barrett D Trustee · Newbury Park, CABuilt 1991 · S/N 029N410WDN410wd LLC · Dallas, TXBuilt 2025 · S/N 18283299N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578N410WPHamlin Andrew J · Two Rivers, AKBuilt 2022 · S/N 001VN41108Winney Andrew J · Gothenburg, NES/N 28-7505195N4110HKoerkenmeier James J · Carlyle, ILBuilt 1978 · S/N 24-0626N4110PSkyway LLC · Bronx, NYBuilt 1998 · S/N 2843143N4110XFoss Michael H · Niagara Falls, NYBuilt 1968 · S/N 208N4110ZJohnson Airspray Inc · Argyle, MNBuilt 1965 · S/N 18-8131N4111JWarmuth Richard J · West Harrison, INBuilt 1966 · S/N 28-22426N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N4111YHousley Jaclyn R · Wasilla, AKBuilt 1976 · S/N 946-76N4111ZBredin Thomas W · Anchorage, AKBuilt 1964 · S/N 18-8153N4112Feltmann Dean A · North Charleston, SCBuilt 1966 · S/N TE-159N4112HGroves Carl Jr · Lebanon, TNBuilt 1978 · S/N 24-0627N41130Chapa Jana K · Corpus Christi, TXS/N 18255794N41139Blair Mark Winston · Zachary, LAS/N R18200889N4113EEllenburg Sixth Family Limited Partnership · Anchorage, AKBuilt 1978 · S/N 18-7809071N4113HWettstein Tim · Manhattan Beach, CABuilt 1978 · S/N 24-0628N4113JParnell Jerry L Jr · Panama City, FLBuilt 1966 · S/N 28-22429N4113XDyer Dillon G · Clatskanie, ORBuilt 1968 · S/N 210N4113YKlintrin Collectibles LLC · Downers Grove, ILBuilt 1976 · S/N 591-76N4114Stauder Gregory P · Galena, ILBuilt 1968 · S/N 413N4114BGrove Mark T · Cave Creek, AZBuilt 1993 · S/N 14598N4114JCrader Air LLC · Jackson, MOBuilt 1966 · S/N 28-22430N4114KNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1966 · S/N 25-4043N4114SHeffernan Duane C · Moravia, NYS/N CE-434N4114XDaniel William G Jr · Penhook, VABuilt 1968 · S/N 211N4114YLight & Variable LLC · Arlington, VABuilt 1976 · S/N 947-76N4115CHails Betsy B · Montgomery, ALBuilt 1978 · S/N R18200325N4115EBcs Properties LLC · Mead, COBuilt 1978 · S/N 18-7809072N4115HPeters Alan M · Arcola, TXBuilt 1947 · S/N 12-3548N4115SDanielson Adam M · Chassell, MIS/N TH-644
Back to AD 2007-04-19 R1