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.

N431MARegent Trust Corporation Trustee · Wichita, KSBuilt 2022 · S/N 1200-2022N431MLFarr Francis A · Bozeman, MTBuilt 1975 · S/N 18263538N431NSSarkinen Scott W · Amboy, WABuilt 2026 · S/N P412N431RAJimenez Raymond C · Gardena, CABuilt 1990 · S/N 31N431RMPierzchalski Aidan K · Stevenson Ranch, CABuilt 2004 · S/N 2843600N431SAArgotsinger Michael · Wichita, KSBuilt 2004 · S/N 952-2004N431SMPongracz Brian · Redding, CABuilt 2002 · S/N 90409N431SPMoreno Jose J · Irvine, CABuilt 1961 · S/N D-6799N431SSSmith Simon K · Janesville, WIBuilt 2007 · S/N 555RN431WRettenmaier Kim J · Columbia, MOBuilt 1969 · S/N 28R-35277N432Lazy J Aeroplanes LLC · Beverly, WVBuilt 1974 · S/N TC-1649N43200Robertson Charles V II · Amarillo, TXFirst renewal noticeBuilt 1974 · S/N 28-7425344N43201Paul Richard · Fresno, CAS/N 28-7415443N43206Hower Phillip G · Seabeck, WABuilt 1974 · S/N 28-7415444N43208Thornburgh Paul J Trustee · Sun Prairie, WIBuilt 1974 · S/N 28-7415445N4320AKnutson Daniel T · Lodi, WIS/N 22-3672N4320FSkippys Sky Scooter LLC · Jenks, OKBuilt 1976 · S/N 28-7715016N4320JHaddle Eddie · Lindon, UTBuilt 1967 · S/N 28-22694N4320MKoinzan Flying Service Inc · Elgin, NEBuilt 1947 · S/N 12-3256N4320TBsrp III LLC · Hickory, NCBuilt 1988 · S/N 3213014N4320ZSchermerhorn Lee V D III · Oak Harbor, WABuilt 1968 · S/N 18-8633N43214Bellard Cedric · Valrico, FLBuilt 1974 · S/N 28-7415446N43215Gremel Tyler · Ellensburg, WABuilt 1974 · S/N 28R-7435254N43218On Final Aviation LLC · Brookland, ARBuilt 1974 · S/N 28-7425345N43219Stading William T · Hackensack, MNBuilt 1974 · S/N 28-7415447N4321EHarper Henry Jr · Mesquite, NVS/N D-8868N4321FVales Louis · Monroe, NYBuilt 1976 · S/N 28R-7635455N4321JN51343 LLC · Newnan, GABuilt 1967 · S/N 28-22695N4321QW H Flying Club Inc · Kingston, MIS/N 17260221N4321SBeech Peak Aviation LLC · Boulder, COBuilt 1964 · S/N D-7512N4321TSale Reported · Signal Hill, CASale reportedBuilt 1971 · S/N 28R-7235007N4321XGrady Auctions & Realty Inc · Newport, ARBuilt 1965 · S/N 21058623N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607N43221Bednarz Joseph P · Hendersonville, TNBuilt 1974 · S/N 28-7405181N43224Piper Aviation LLC · Tierra Verde, FLBuilt 1974 · S/N 28-7425346N4322FAdk Xc Flyers LLC · Scotia, NYBuilt 1976 · S/N 28R-7635456N4322GMid Atlantic Air Museum · Reading, PABuilt 1971 · S/N 032N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696N4322RKing Air Charter LLC · Zanesville, OHBuilt 1978 · S/N R18200590N4322WSnell Steve · Scotts Valley, CABuilt 1974 · S/N D-9589N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015N4322ZLee Gerald R · Glennallen, AKBuilt 1968 · S/N 18-8636N43232N43232 LLC · Orange, TXBuilt 1974 · S/N 28-7415450N43234Level Up Aviation LLC · Newton, ALBuilt 1974 · S/N 28-7415451N4323BBkt Holdings LLC · Mont Belvieu, TXBuilt 1983 · S/N 46-8408009N4323HRucker Edward A · Longview, TXS/N 24-0704N4323POverspray LLC · Norfolk, NEBuilt 1983 · S/N 46-8408013N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076N4323TBreitenstine Matthew · Dallas, TXBuilt 1971 · S/N 28R-7235008
Back to AD 2007-04-19 R1