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.

N3316RBranstetter Jack · Ponca City, OKS/N 18258616N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129N3317FPeniston Mandy J · Chillicothe, MOBuilt 1966 · S/N 18257317N3317MJacobs Robert E · Santa Fe, NMBuilt 1947 · S/N 12-2172N3317RBanti Gustavo · Marco Island, FLBuilt 1967 · S/N 18258617N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617N3317USierra Aviation LLC · Fond Du Lac, WIBuilt 1963 · S/N 18254717N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118N3318RPetersen Family 1999 LLC · Anchorage, AKS/N 18502872N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627N3319MWhirley Bradley J · Brainerd, MNBuilt 1947 · S/N 12-1883N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119N331AHArmstrong Helicopters LLC · Laredo, TXBuilt 2003 · S/N 10042N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373N331BHBurks Aviation Inc · Hattiesburg, MSBuilt 1995 · S/N 06N331BXFay Craig J · Fairfax Station, VABuilt 1967 · S/N 310L-0168N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747N331CHCh Wings LLC · Arvada, COBuilt 2022 · S/N 172S12917N331CPCivil Air Patrol · Montgomery, ALBuilt 2019 · S/N 172S12342N331CSBauer Matthias · Ann Arbor, MIS/N D-7126N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164N331DHEaves Donald Ray · Byhalia, MSFirst renewal noticeBuilt 2000 · S/N 21754N331DJMugford David Allen · Annapolis, MDBuilt 2007 · S/N 40331N331DPAguayo Domingo · Marco Island, FLBuilt 1965 · S/N CD-954N331DWHaehnel Patrick J · Elbert, COBuilt 2001 · S/N 001N331EBEberly Mark H · Carmel, INBuilt 1976 · S/N CE-651N331ELNantucket Helicopters LLC · Nantucket, MABuilt 2023 · S/N 14667N331ESJackson Paul D · Chesapeake, VAFirst renewal noticeBuilt 2001 · S/N 1067N331FBurton Charles E · Jackson, CABuilt 2001 · S/N 5703N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277N331GTPope Kent M · Hayden, IDBuilt 1984 · S/N 331N331GWFieldcrest Air LLC · Latrobe, PABuilt 2021 · S/N 18283147N331HKCharter Scott R · Manistique, MIBuilt 1960 · S/N D-6313N331JArndt Brent · Kodiak, AKBuilt 2023 · S/N 1331N331JBBostik Josef J · Green Cove Springs, FLBuilt 2002 · S/N 25108N331JHStack Trevor J · Keller, TXBuilt 2005 · S/N 40142N331JKKenzy 2020 LLC · Aurora, ORBuilt 2021 · S/N 172S12751N331JRLeclercq Benoit B · Saint Cloud, FLBuilt 1992 · S/N 5241N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028N331MDMedmission Supplies LLC · Escondido, CABuilt 2018 · S/N 90991N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464
Back to AD 2007-04-19 R1