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.

N413BSSpeck Enterprises LLC · Missoula, MTBuilt 2013 · S/N 40955N413BXAlbrecht Devin C · Shavertown, PABuilt 1989 · S/N 22N413CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13239N413CCMikkelsen Timothy O · Wasilla, AKBuilt 2013 · S/N CC18-0065N413CSGolf Romeo Charlie LLC · Elk Grove, CABuilt 2016 · S/N 18282413N413DBEstelle Karsen · Mc Neal, AZBuilt 2003 · S/N 1299N413DGWindsock Capital LLC · Bertram, TXBuilt 1959 · S/N 35814N413DPYale Companies LLC DBA · Fishers, INBuilt 2006 · S/N 4496234N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113N413EEReyenga Steven G · Shreveport, LABuilt 1962 · S/N D-6999N413EFIsland Aviation LLC · East Greenwich, RIBuilt 1974 · S/N 28R-7435173N413EM413em LLC · Columbia, ILBuilt 2005 · S/N 29-0388N413EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12640N413GKKgc Holdings Ltd · Newark, TXBuilt 1973 · S/N D-9450N413JN413j LLC · Locust Grove, GABuilt 1964 · S/N TC-831N413JSClearwake Inc · Kaysville, UTBuilt 1984 · S/N 8042-CN413KGEagle Mountain International Church Inc · Newark, TXBuilt 1976 · S/N TE-1076N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307N413KSMatteo Properties · Wickliffe, OHS/N 333N413KTAce Tomato Company LLC · Mcgregor, TXBuilt 2005 · S/N 2843608N413LBOficinas De Carolina Inc · San Juan, PRBuilt 1981 · S/N 18504200N413LFFreed Rodney W · Mount Vernon, WABuilt 2024 · S/N 20625N413LMRba LLC · Kimberly, IDBuilt 2007 · S/N 60396N413MBrookway Investments LLC · Brookhaven, MSBuilt 1977 · S/N E1151N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164N413MFRegistered aircraftBuilt 2015 · S/N 18282412N413NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010006N413PTag Aviation LLC · Larwill, INBuilt 2004 · S/N 1073N413PGSchaefer John A · Waterloo, ILBuilt 1951 · S/N 22167N413PMJl Bonanza LLC · Keller, TXBuilt 2011 · S/N E-3968N413RDDos Amigos Air Service LLC · Carrizo Springs, TXBuilt 2004 · S/N 18281464N413SLMilestone Plane LLC · Wilmington, DEBuilt 1988 · S/N CE-1289N413TAInfinite Runway LLC · Union City, CABuilt 1981 · S/N 18267922N413THPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020252N413WCBradshaw Larry C · Edgewood, TXBuilt 2009 · S/N 91607N413WGHavana Farms Equipment · Gilliam, LABuilt 1976 · S/N E-804N413WPKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1261-99N413WWWilkinson Jason S · Eastvale, CABuilt 1972 · S/N 340-0176N413YKGoodner Terry Jack · Port Saint Lucie, FLS/N 818N413ZPPettinger Tom W · Cody, WYBuilt 2004 · S/N 8-4705N41402Isofly LLC · Canyon Country, CABuilt 2008 · S/N 1934N4140GCaribbean Development Partnership Ltd · Wilmington, DEBuilt 1977 · S/N 340A0311N4140JStone Raymond M · Moore, OKBuilt 1966 · S/N 28-22464N4140PRenda Gregory L · Saratoga, CABuilt 1999 · S/N 21064CN4140WBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843228N4140XOtt Dean R · Carrollton, OHS/N 240N4140ZMeierotto Jeff T · Two Rivers, AKBuilt 1965 · S/N 18-8213N41411Aerinova Inc · Mattoon, ILBuilt 2008 · S/N 12429N41412Walters Haskell L · Gold Hill, NCBuilt 1974 · S/N 28-7415204N41415Cavins Todd J · Stillwater, OKBuilt 1974 · S/N 28-7405101
Back to AD 2007-04-19 R1